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

0 vote110 views3 answers
Laravel validation alphanumeric with spaces
PHP Laravel
33 votes106 views4 answers
Carbon format date in laravel
PHP Laravel
28 votes125 views6 answers
Laravel drop foreign key
PHP Laravel
9 votes112 views6 answers
Pluck laravel
PHP Laravel
3 votes114 views1 answer
Laravel send post request from controller
PHP Laravel
15 votes118 views3 answers
Laravel setup auth
PHP Laravel
2 votes120 views2 answers
How unset request parameter in laravel
PHP Laravel
1 vote126 views1 answer
Laravel cashier overwrite users table name
PHP Laravel
1 vote109 views2 answers
Db name laravel
PHP Laravel
0 vote167 views1 answer
Manual collection laravel
PHP Laravel