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');
使用函数的方法,记下笔记而已