用相同的行数逗号分隔值

荣皓

数据库结构
name ：id, name
username ：id, username
user_items ：id, user_id, item_id
我目前在count()上user_items显示了拥有最多项目的用户：
john: 13
bill: 9
lily: 9
kent: 9
seth: 8
vick: 8
anna: 7
但是我想以这种方式显示它：
13: john
9: bill, lily, kent
8: seth, vick
7: anna
如何在刀片服务器中使用laravel的查询系统来实现此目的？

解决方案:


            在控制器中得到这样
$users = DB::table('user_items as ui')
->select('count',DB::raw("group_concat(name SEPARATOR ', ') as names"))
->from(DB::raw('(select count(*) as count,u.username as name from user_items ui  join users u on u.id=ui.user_id  group by u.id) a'))
->groupBy('count')
->orderBy('count','desc')
->get();
$data['users']=$users;
return View::make('hello',$data);
在视图中使用刀片
@foreach($users as $user)
  {{$user->count.':'. $user->names}}
@endforeach
如果希望不显示任何项目的用户，则可以查询
$users = DB::table('users as u')
         ->select('count',DB::raw("group_concat(name SEPARATOR ', ') as names"))
         ->from(DB::raw('(select count(ui.item_id) as count,u.username as name from users u  left join user_items ui on u.id=ui.user_id  group by u.id) a'))
         ->groupBy('count')
         ->orderBy('count','desc')
         ->get();
要单独显示名称，请在前面添加以下代码 $data['users']=$users;
foreach($users as $user){
         $user->names=explode(', ',$user->names);
}
而在刀片中，您可以

@foreach($users as $user)

         {{$user->count}}:
         @foreach($user->names as $index=>$name)
            {{$name}} @if($index!=count($user->names)-1) ,@endif
         @endforeach

@endforeach

用相同的行数逗号分隔值

荣皓 LV1