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

2 votes205 views1 answer
Get the current route in laravel
PHP Laravel
2 votes228 views3 answers
Php remove quotes from string
PHP
1 vote233 views1 answer
Update to php 7.4
PHP
2 votes222 views2 answers
How to make doctrine schema update in symfony 2.8
PHP
2 votes194 views1 answer
Check if div is empty javascript
PHP
15 votes226 views1 answer
Composer install ignore platform reqs
PHP
4 votes213 views2 answers
Php sort hight to low
PHP
0 vote236 views1 answer
Meyfa/phpunit-assert-gd[v2.0.0, ..., v2.x-dev, v3.0.0] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension
PHP
0 vote237 views1 answer
Disable laravel cors
PHP
0 vote231 views1 answer
Increase php_values
PHP