tp5语法 group by 和count(*)连用

Question

like 表字段idtypeid 文章iduserid 用户idstatus 赞状态 1:已点赞 0：未点赞 想知道某文章id为1,2,3,4的总赞数，不知道怎么用tp5写原生sql="select typeid,count(*) from like where typeid in (1,2,3,4) and user_id = 14 and status =1 group by typeid"; tp5只知道这么写$ids= '1,2,3,4';LikeModel::where('typeid','in',$ids)->where(['user_id'=>14,'status'=>1)->group('typeid')->select(); 没有用上count(*) 我想实现 typeid count(*)1 12 23 24 1

Answer 1

其实这个要用到filed这个方法,例子

LikeModel::where('typedid','in',$ids)
    ->where(['user_id'=>14,'status'=>1])
    ->filed('typeid,COUNT(*) as total')
    ->group('typeid')
    ->select();

没有太过于去查看,大概就这个意思