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

1 vote223 views1 answer
Display summernonte data with string limit laravel
PHP Laravel
6 votes215 views4 answers
Laravel create project command
PHP Laravel
0 vote204 views2 answers
Laravel model column default value
PHP Laravel
5 votes213 views2 answers
In laravel date duration validation rule
PHP Laravel
0 vote279 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
10 votes216 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
10 votes229 views2 answers
Laravel array to string conversion
PHP Laravel
9 votes232 views2 answers
A facade root has not been set laravel
PHP Laravel
0 vote219 views1 answer
Populate old value of dropdown laravel
PHP Laravel
0 vote242 views2 answers
Convert string to array laravel
PHP Laravel