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 vote208 views1 answer
Laravel faker value or null
PHP Laravel
6 votes182 views6 answers
Composer install laravel
PHP
1 vote289 views1 answer
Laravel eloquent get only field name
PHP
0 vote166 views1 answer
Hash not found laravel
PHP
0 vote201 views1 answer
How to add logo in FPDF PHP
PHP
0 vote218 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote205 views1 answer
Return json in middleware laravel
PHP Laravel
0 vote184 views1 answer
Acf if image else display other image
PHP
0 vote239 views1 answer
Laravel random value from array
PHP
1 vote181 views2 answers
Is home page if wordpress
PHP