thinkphp 查询数据库数据根据两个字段group,且统计条数用法
$result=M("sale_lead") ->field("lead_source,created_by,count(sale_lead_id ) as count_num") ->group("lead_source,created_by") ->where($where) ->select();
结果:
array(14) { [0] => array(3) { ["lead_source"] => string(1) "1" ["created_by"] => string(2) "42" ["count_num"] => string(1) "1" } [1] => array(3) { ["lead_source"] => string(1) "3" ["created_by"] => string(2) "43" ["count_num"] => string(1) "1" } [2] => array(3) { ["lead_source"] => string(1) "4" ["created_by"] => string(2) "29" ["count_num"] => string(1) "2" } [3] => array(3) { ["lead_source"] => string(1) "5" ["created_by"] => string(2) "29" ["count_num"] => string(1) "1" } [4] => array(3) { ["lead_source"] => string(1) "5" ["created_by"] => string(2) "42" ["count_num"] => string(1) "1" } [5] => array(3) { ["lead_source"] => string(1) "6" ["created_by"] => string(2) "29" ["count_num"] => string(1) "2" } [6] => array(3) { ["lead_source"] => string(1) "7" ["created_by"] => string(2) "42" ["count_num"] => string(1) "1" } [7] => array(3) { ["lead_source"] => string(1) "7" ["created_by"] => string(2) "43" ["count_num"] => string(1) "2" } [8] => array(3) { ["lead_source"] => string(1) "8" ["created_by"] => string(2) "42" ["count_num"] => string(1) "5" } [9] => array(3) { ["lead_source"] => string(1) "8" ["created_by"] => string(2) "43" ["count_num"] => string(1) "2" } [10] => array(3) { ["lead_source"] => string(2) "13" ["created_by"] => string(2) "43" ["count_num"] => string(1) "1" } [11] => array(3) { ["lead_source"] => string(2) "43" ["created_by"] => string(2) "43" ["count_num"] => string(1) "2" } [12] => array(3) { ["lead_source"] => string(2) "44" ["created_by"] => string(2) "43" ["count_num"] => string(1) "1" } [13] => array(3) { ["lead_source"] => string(2) "45" ["created_by"] => string(2) "43" ["count_num"] => string(1) "1" } }
声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。