mysql 根据where条件，分组，联表等统计数据条数
标签：font 方法 sql yii com man sele create 遇到
mysql 根据where条件，分组，联表等统计数据条数
"SELECT count(*) as totalNum from beauty_photos as p left join beauty_user as u on p.uid=u.id where p.status=1 and p.is_delete=0 and u.is_delete=0 group by p.uid";
$count = \Yii::$app->db4->createCommand($sql)->queryAll();