use yii\db\Expression;
$arQuery = self::find()
->select(['*', new Expression('count(*) as count'), new Expression('FROM_UNIXTIME(create_time,"%Y年%m月%d日") as day')]);
$arQuery->where($where);
return $arQuery->orderBy('count desc')->groupBy('day');
使用函数的方法,记下笔记而已
需要加上asArray()函数才会显示数据
$list = $query->asArray()->all()
————————————————
版权声明:本文为CSDN博主「snow12138」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/snow12138/article/details/54405574