PHP

count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')
	->get();

count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')    
	->get();

count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')gg
	->get();

join table laravel count

DB::table('users')
        ->join('contacts', function($join)
        {
            $join->on('users.id', '=', 'contacts.user_id')->orOn(...);
        })
        ->get();

join table laravel count

DB::table('users')
        ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
        ->get();

laravel join with count

Try something like this

DB::table('website_tags')
->join('assigned_tags', 'website_tags.id', '=', 'assigned_tags.tag_id')
->select('website_tags.id as id', 'website_tags.title as title', DB::raw("count(assigned_tags.tag_id) as count"))
->groupBy('website_tags.id')
->get();

laravel left join count

  $rating = User::query()
            //            ->where('users.ban', '!=', 1)
            //            ->where('users.rights', '!=', 0)
            ->leftJoin('users as referal', 'users.id', '=', 'referal.ref_id')
            ->whereNotNull('referal.id')
            ->select([
                'users.id',
                'users.name',
                'users.rating',
                'users.status_name',
                'users.status_id',
                'users.telegram_id',
                DB::raw('count(referal.id) as total_referal')
            ])
            ->groupBy('users.id')
            ->orderByDesc('total_referal')
            ->limit(15)->get()->toArray();