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 votes235 views4 answers
Print last query laravel
PHP Laravel
46 votes173 views6 answers
Add column to migration laravel
PHP
0 vote183 views1 answer
Order table in laravel
PHP Laravel
3 votes163 views1 answer
Laravel e commerce full project
PHP
1 vote193 views1 answer
Laravel websockets onmessage
PHP
0 vote175 views2 answers
Current url wordpress
PHP
9 votes158 views3 answers
Laravel where closure
PHP
1 vote159 views1 answer
Php get content phpinfo without show
PHP
0 vote170 views1 answer
Joomla cache programing clear
PHP
0 vote167 views1 answer
Laravel display old value in form
PHP