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

0 vote441 views1 answer
Codeigniter how to know update failed
PHP CodeIgniter
0 vote374 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
23 votes316 views6 answers
Laravel 6 auth
PHP Laravel
6 votes345 views3 answers
Laravel route namespace
PHP Laravel
8 votes404 views1 answer
How to migrate single table in laravel
PHP Laravel
0 vote383 views1 answer
Get post data in laravel
PHP Laravel
0 vote338 views1 answer
Alternatively, you may set the environment variables ONIG_CFLAGS and ONIG_LIBS to avoid the need to call pkg-config.
PHP
0 vote462 views3 answers
Laravel 7 factory tinker
PHP Laravel
3 votes317 views4 answers
Filesize in php
PHP
14 votes369 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel