thinkphp 查询数据库数据根据两个字段group，且统计条数用法

最新推荐文章于 2024-06-07 16:10:36 发布

原创最新推荐文章于 2024-06-07 16:10:36 发布 · 1.3w 阅读

6 ·

CC 4.0 BY-SA版权

文章标签：

#thinkphp #group #TP框架

php 专栏收录该内容

100 篇文章

订阅专栏

本文介绍了一种针对销售线索来源及其创建者的统计方法，通过对销售线索数据库进行分组查询，详细展示了不同来源和创建者组合下线索的数量分布情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

$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"
  }
}