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 vote151 views1 answer
Import class route laravel
PHP
0 vote158 views1 answer
Laravel-medialibrary packagist
PHP Laravel
39 votes123 views4 answers
Php artisan make:controller --resource command
PHP
1 vote157 views1 answer
Php include once inside a function?
PHP
0 vote142 views1 answer
Window.location javascript php
PHP
12 votes122 views6 answers
Php array push key value
PHP
0 vote162 views1 answer
Sass for php
PHP
0 vote169 views1 answer
Deactivate auto update wordpress plugins
PHP Wordpress
3 votes154 views5 answers
What does php stand for
PHP
1 vote129 views1 answer
Codeigniter where date interval
PHP