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 votes134 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote109 views1 answer
Optimistic Locking Laravel
PHP
0 vote126 views2 answers
Laravel loop variable
PHP Laravel
2 votes101 views1 answer
Grep only in php files
PHP
0 vote98 views2 answers
Php json request get value of an array element
PHP
0 vote161 views1 answer
Symfony flash message
PHP Symfony
0 vote103 views1 answer
Thems
PHP
2 votes113 views3 answers
Laravel get input from request
PHP
4 votes130 views1 answer
Disable register laravel
PHP Laravel
0 vote117 views1 answer
Laravel launch only one dusk test
PHP