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

0 vote316 views1 answer
Use id as key in co;lection laravel
PHP Laravel
0 vote290 views1 answer
How to pluck fullname database laravel
PHP Laravel
1 vote310 views2 answers
Laravel generate unique token
PHP Laravel
3 votes310 views1 answer
Laravel cannot create an instance of class viewmodel
PHP Laravel
5 votes295 views2 answers
Set unique value validation for laravel form request
PHP Laravel
24 votes273 views4 answers
Where not null in laravel
PHP Laravel
0 vote320 views1 answer
Laravel import csv to database
PHP Laravel
0 vote297 views1 answer
Laravel 8 clear compiled class files
PHP Laravel
0 vote287 views1 answer
Laravel vue build production
PHP Laravel
0 vote269 views1 answer
Indian time laravel
PHP Laravel