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

1 vote116 views1 answer
Woocommerce add custom field data to cart page
PHP
0 vote134 views1 answer
Php interview questions for experience
PHP
0 vote125 views2 answers
Ã„ convert orignal character php
PHP
3 votes167 views6 answers
Laravel find query
PHP Laravel
0 vote122 views1 answer
German locale php
PHP
0 vote164 views1 answer
Wordpress single post template managwr
PHP Wordpress
0 vote152 views1 answer
Get previous url symfony 4 in formpage
PHP
1 vote134 views1 answer
Select sum in laravel
PHP Laravel
1 vote149 views1 answer
HTML Snippets not working in .php files
PHP
0 vote188 views1 answer
Delay queue laravel
PHP Laravel