With function laravel

Laravel where has

use Illuminate\Database\Eloquent\Builder;

// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
})->get();

// Retrieve posts with at least ten comments containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
}, '>=', 10)->get();

Source: laravel.com

With function laravel

Post::query()
    ->with(array('user' => function($query) {
        $query->select('id','username');
    }))
    ->get();

Similar codes

1 vote217 views1 answer
Select selected fields in laravel join
PHP Laravel
1 vote269 views1 answer
Autoload file in laravel
PHP Laravel
0 vote234 views6 answers
Pass all data to all pages laravel
PHP Laravel
2 votes249 views2 answers
Laravel migration two primary key
PHP Laravel
5 votes261 views2 answers
Laravel groupby and latest
PHP Laravel
0 vote231 views1 answer
How to collapse array in laravel
PHP Laravel
0 vote211 views1 answer
Laravel route name with parameters
PHP Laravel
4 votes201 views2 answers
Laravel DB wherein
PHP Laravel
0 vote238 views1 answer
Write if and else in one line laravel
PHP Laravel
-1 vote251 views1 answer
Laravel migration table bigint
PHP Laravel