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 vote263 views1 answer
Laravel blade array seearch select box
PHP Laravel
3 votes258 views3 answers
Laravel pagination having raw query not working
PHP Laravel
0 vote253 views1 answer
Get 1 data from get laravel
PHP Laravel
1 vote256 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
3 votes256 views2 answers
Set image asset path in laravel
PHP Laravel
0 vote265 views1 answer
Create laravel project 8.16.1
PHP Laravel
2 votes273 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote242 views1 answer
Query builder laravel getmedia undefined method
PHP Laravel
11 votes249 views4 answers
Redirect back with input laravel in request
PHP Laravel
15 votes259 views4 answers
Change existing migration laravel
PHP Laravel