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

39 votes108 views6 answers
Create table laravel
PHP Laravel
0 vote105 views2 answers
All() in laravel
PHP Laravel
1 vote117 views2 answers
Laravel check if object is empty
PHP Laravel
0 vote110 views1 answer
Laravel permission create role
PHP Laravel
0 vote110 views2 answers
Laravel loop variable
PHP Laravel
0 vote114 views1 answer
Publish algolia search in laravel
PHP Laravel
0 vote99 views1 answer
Laravel login shows 404
PHP Laravel
3 votes115 views1 answer
Laravel check if environment is production
PHP Laravel
0 vote104 views1 answer
Laravel 8 date difference in days
PHP Laravel
45 votes151 views6 answers
Laravel outer join
PHP Laravel