php count group by同时用,thinkphp group by count如何同时使用？分页用到

分页前，需要获取记录条数

$count = M('abc')->where($where)->count();

但是, 如果查询还需要使用到 GROUP BY的话

$count = M('video_log')->where($where)->group('ip')->count();

这样是等不到正确条数的，得到的还是总条数

怎样实现呢，需要借助原生sql语句

方法1：参考网址https://www.qiusuoweb.com/71.html

//SQL_CALC_FOUND_ROWS记录查询条数

//在测试中发现，mysql5.7中添加关键词SQL_CALC_FOUND_ROWS不是必须的。

Db::query("select SQL_CALC_FOUND_ROWS date('time') as date from users group by date");

//found_rows()获取以上查询记录的条数

$count = Db::query("select found_rows() as count");

自己用

Db::query("select * from my_video_log group by ip");

$count = Db::query("select found_rows() as count");

方法2：参考网址https://blog.csdn.net/weixin_37946518/article/details/89550409

SELECT COUNT(DISTINCT column_1, column_2) FROM tablename WHERE conditions

其中第二条的 column_1, column_2与第一条的GROUP BY 后的字段要保持一致(字段数量和顺序)

自己用

$rs = Db::query("SELECT COUNT(DISTINCT ip) as count FROM my_video_log");

$count = $rs[0]['count'];