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

0 vote139 views2 answers
Laravel apiresource
PHP Laravel
0 vote175 views1 answer
Php laravel convert blob type to string
PHP Laravel
0 vote141 views1 answer
Controller class does not exist laravel
PHP Laravel
4 votes153 views2 answers
Laravel request all delete _token
PHP Laravel
-1 vote138 views2 answers
Random number laravel faker
PHP Laravel
1 vote142 views1 answer
Laravel add crf token form
PHP Laravel
0 vote151 views1 answer
Get base class name laravel
PHP Laravel
0 vote164 views1 answer
Validate file count with validate in laravel
PHP Laravel
0 vote107 views1 answer
Eager realationship in laravel
PHP Laravel
0 vote141 views1 answer
Laravel migration add date of birth column
PHP Laravel