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

2 votes314 views5 answers
Laravel installation in windows
PHP Laravel
30 votes348 views6 answers
Laravel migration column types
PHP Laravel
2 votes347 views1 answer
Return back in blade laravel
PHP Laravel
0 vote362 views1 answer
Creating default object from empty value laravel
PHP Laravel
0 vote388 views1 answer
Laravel console example
PHP Laravel
0 vote378 views1 answer
Controller class does not exist laravel
PHP Laravel
0 vote377 views1 answer
Query without chaining not working - Laravel
PHP Laravel
1 vote365 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
3 votes393 views3 answers
Laravel get certain columns
PHP Laravel
0 vote409 views1 answer
Laravel eloquent hasmany select
PHP Laravel