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 vote102 views1 answer
Add field to migration laravel
PHP
0 vote114 views1 answer
"ajax": { "url": "<?php echo site_url('transaction/loadfirmwaterinfo')?>", "type": "POST", data: {x:x}, },
PHP
4 votes137 views2 answers
Get permalink by id wordpress
PHP Wordpress
0 vote153 views1 answer
How to convert php code to html
PHP
2 votes134 views1 answer
Laravel eloquent update pivot table
PHP
0 vote121 views1 answer
Localhost/series/my database/demo.php
PHP
0 vote184 views1 answer
Laravel joins eloquent model
PHP Laravel
2 votes152 views3 answers
How to share a helper globally laravel
PHP Laravel
8 votes111 views6 answers
Php scandir
PHP
0 vote138 views1 answer
Php-oop
PHP