php - 在 Laravel 中从数据库中独特地选择列

Question

我已经在数据库中连接了三个表，现在我想在区域表中独特地选择列区域中的值，并计算连接表中重复的每个区域的计数。下面的代码是我如何加入城市、商店和区域表，

$zones= Store::join('cities as c','store.city_id','=','c.id')
        ->join('zones as z','c.zone_id','=','z.id')
        ->get();

Answer 1

试试这个:

$zones= Store::join('cities as c','store.city_id','=','c.id')
        ->join('zones as z','c.zone_id','=','z.id')
        ->select(DB::raw('count(z.id) as z_count, z.*'))
        ->groupBy('z.id')
        ->get();