yii2实现分组取最新数据 $sql = 'SELECT id from (SELECT id,article_id FROM 表名 order by create_time desc limit 10) 表名 group by article_id ORDER BY id DESC;'; $commentHot = \Yii::$app->db->createCommand($sql, [':id' => 1])->queryAll();