$hot_new_by_adduser = Yii::$app->getDb()
->createCommand("select count(*) as count,al_add_user_id from ar_list GROUP BY al_add_user_id HAVING count > 8 order by count desc limit ".($page-1).",6")
->queryAll();
$page = ($page-1)*6
最后转换为如下:
$page = 1 => $page=0
$page = 2 => $page=6
$page = 3 => $page=12
…