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 vote115 views1 answer
With() multiple relationship
PHP
3 votes173 views1 answer
Get soft deleted data laravel
PHP
0 vote114 views1 answer
Symfony see all make command
PHP
1 vote146 views3 answers
Wp site url link from admin
PHP Wordpress
0 vote122 views2 answers
Export database to sql dump in php
PHP
45 votes168 views6 answers
Laravel run seeder
PHP
7 votes151 views6 answers
Sort laravel eloquent
PHP Laravel
9 votes123 views2 answers
Use resource in laravel 8
PHP
1 vote169 views3 answers
Codeigniter store session data
PHP CodeIgniter
3 votes122 views2 answers
How to get time php with am/pm
PHP