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

3 votes325 views1 answer
Laravel get project root
PHP Laravel
0 vote329 views1 answer
Distinct laravel not working
PHP Laravel
0 vote336 views1 answer
Laravel-5-on-shared-hosting-wrong-public-path
PHP Laravel
-1 vote362 views6 answers
How to install bootstrap in laravel 8
PHP Laravel
0 vote331 views2 answers
Laravel orm tutorial
PHP Laravel
0 vote333 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
47 votes349 views6 answers
How to run specific seeder in laravel
PHP Laravel
1 vote370 views1 answer
Default index page for laravel in cpanel
PHP Laravel
1 vote314 views3 answers
Create new laravel project with specific version
PHP Laravel
1 vote328 views1 answer
Laravel helper function for check string is exist in another string
PHP Laravel