Yii查询生成器(Query Builder)之拼装SQL

$sql = "user_id in (".$userList.") and date_format(date, '%Y%m') = {$date} and type = {$type}";
        $data= Yii::app()->db->createCommand()->from("{{reminder_sales}}")
            ->select("*")
            ->where($sql)
            ->group('user_id')
            ->text;

        $data= Yii::app()->db->createCommand()->from("($data) as v")
            ->select('count(*) as total')
            ->queryScalar();

参考链接
https://www.jb51.net/article/54749.htm