select 统计多个字段
$where['e.type'] = $qun_type;
$db=db('dingding_ewms')
->alias('e')
->field(["count(u.is_long_touch=1 or null)"=>'num_long',"count(u.id)"=>'num_id','e.id,e.name,e.on_time,e.off_time'])
->join('dingding_user_count u','u.bind_qun=e.id')
->where($where)
->order('e.id desc')
->group('e.id');
引用http://blog.csdn.net/abountwinter/article/details/47083211
Db::table(['member'=>'m'])
->field(["count(m.member_id)"=>'num','a.area_region'])
->join(['area'=>'a'],'m.member_province=a.area_name','LEFT')
->group('a.area_region')->select();