mysql - 使用 Eloquent 行和groupby的总和

Question

有以下列:

category, rating, num_users, date_voted /*number of users*/

如何使用 Eloquent 方式将评分按类别分组为给定日期范围内的用户数量总和

Category::groupBy('num_users') //returns the categories

主表数据示例

--------------------------------
category| rating| num_users| date_voted
---------------------------------------
Action  |5      |2         | 12-12-2015
Comedy  |2      |2         | 12-12-2015
Fantasy |3      |2         | 12-12-2015
Action  |4      |2         | 14-12-2015
Comedy  |5      |2         | 14-12-2015

我希望 html 表采用类别与评级(1 到 5 之间)的形式，例如

-----------------------------------------------------
Category|Rating 1|Rating 2|Rating 3|Rating 4|Rating 5|
------------------------------------------------------
Action  |2       |3       |5       |5       |9       |  
Comedy  |9       |8       |6       |9       |14      | 
Fantasy |1       |2       |3       |6       |7       | 

Answer 1

如果您想按类别获取 num 用户组的总和，您可以使用:

Category::groupBy('category')
->selectRaw('sum(num_users) as num_users , category')
->get();