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

15 votes138 views6 answers
Laravel db transaction
PHP Laravel
9 votes146 views5 answers
Return view with variable laravel
PHP Laravel
49 votes182 views6 answers
Laravel when
PHP Laravel
1 vote141 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
4 votes135 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel
0 vote163 views1 answer
Laravel Can't write image data to path Image::make($image)->resize
PHP Laravel
0 vote127 views1 answer
Laravel add many to many
PHP Laravel
6 votes144 views4 answers
Laravel create project command
PHP Laravel
0 vote194 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
11 votes133 views5 answers
Laravel redirect back url with message
PHP Laravel