Join 2 tables laravel

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Similar codes

8 votes205 views2 answers
Laravel passport
PHP Laravel
0 vote216 views1 answer
How to get webhook response in laravel
PHP Laravel
0 vote151 views1 answer
If notexists in laravel query
PHP Laravel
0 vote211 views1 answer
Laravel str_pad Consecutivo
PHP Laravel
0 vote214 views1 answer
Laravel repository error
PHP Laravel
1 vote208 views1 answer
How delete the table in laravel in the commend
PHP Laravel
11 votes215 views5 answers
Laravel model transaction
PHP Laravel
10 votes201 views3 answers
Get current date carbon laravel
PHP Laravel
50 votes556 views6 answers
Add column in laravel migration
PHP Laravel
0 vote225 views1 answer
Mixed content laravel form target
PHP Laravel