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

43 votes326 views2 answers
Get array length using php
PHP
6 votes378 views5 answers
Migration rename column laravel
PHP Laravel
2 votes342 views2 answers
Prevent form submit on page refresh php\
PHP
2 votes353 views2 answers
If post php
PHP
5 votes392 views1 answer
Eloquent chunk laravel model chunk
PHP Laravel
6 votes324 views1 answer
Get current year laravel blade
PHP
1 vote352 views1 answer
Larave Soft Deletes
PHP
4 votes324 views2 answers
Make a object php
PHP
1 vote348 views1 answer
Laravel make:listner
PHP
0 vote330 views1 answer
Php mysqli date between
PHP