Laravel query count raw

Laravel join

$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

Laravel query count raw

DB::table('users')
	->select('users.*', DB::raw('count(orders.user_id) as count_by_user_id'))
	->join('orders' ,function($join){
		$join->on('orders.user_id', '=', 'users.id');
	})
	->groupBy('users.id')
	->orderBy('users.id', "DESC")
	->get();

Similar codes

10 votes188 views3 answers
Check count in laravel
PHP Laravel
0 vote164 views1 answer
Wordpress change post format
PHP
21 votes166 views3 answers
How to get ip address of pc in php
PHP
17 votes178 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote150 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP
1 vote159 views1 answer
How to set a validation on a value if its not null in laravel php
PHP
0 vote171 views1 answer
In Connection.php line 664:SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema
PHP
0 vote148 views1 answer
Carbon this month first day
PHP
0 vote161 views1 answer
Laravel map the output of the api
PHP
10 votes149 views3 answers
Get firstwod php
PHP