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 vote339 views1 answer
Apache/2.4.46 (win64) openssl/1.1.1j php/7.3.27 server at localhost port 80
PHP
0 vote310 views1 answer
Order by sum() laravel
PHP
1 vote340 views1 answer
Convert php array to javascript json laravel
PHP
36 votes329 views6 answers
Laravel 8 foreign key migration
PHP Laravel
4 votes381 views4 answers
Search in laravel 8
PHP
-1 vote312 views1 answer
How to check if PHP-FPM is running
PHP
0 vote342 views1 answer
How to restrict user to some pages using php
PHP
-2 votes349 views3 answers
Laravel create get id
PHP Laravel
0 vote293 views1 answer
Code php ajout heure
PHP
5 votes332 views6 answers
Laravel 8 auth
PHP Laravel