Join multiple query in laravel

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

Laravel eloquent multiple join with where conditions

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Source: tutsmake.com

Similar codes

0 vote349 views1 answer
Laravel collection forget
PHP
2 votes388 views4 answers
Laravel redirect action
PHP
0 vote445 views1 answer
Drupal 9 remove field from view
PHP Drupal
0 vote360 views1 answer
Route login not defined how to laravel problems fixed
PHP
-2 votes337 views3 answers
Array flat php
PHP
1 vote342 views1 answer
Get array from multidimensional array
PHP
0 vote318 views1 answer
Edit a row from databse using php
PHP
1 vote367 views1 answer
Run laravel mix
PHP
0 vote339 views1 answer
Laravel repository update multiple row
PHP
0 vote305 views2 answers
Yii2 set cookie
PHP