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 votes229 views2 answers
Assert file exists laravel
PHP Laravel
0 vote218 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel
0 vote230 views1 answer
PaymentIntent::create laravel
PHP Laravel
9 votes268 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
0 vote230 views1 answer
Get all users created in a month laravel
PHP Laravel
2 votes219 views1 answer
Laravel mix purge css
PHP Laravel
0 vote221 views2 answers
Laravel storage link without command line
PHP Laravel
28 votes227 views6 answers
Laravel make model with migration
PHP Laravel
37 votes262 views6 answers
Laravel create or update
PHP Laravel
1 vote294 views1 answer
Boot method laravel
PHP Laravel