$check_info = $checkModel->field('
sum(case when typeId=1 then 1 else 0 end) as zc,
sum(case when typeId=2 then 1 else 0 end) as cd,
sum(case when typeId=3 then 1 else 0 end) as zt,
sum(case when typeId=4 then 1 else 0 end) as qj,
sum(case when typeId=4 then 1 else 0 end) as qj,
sum(case when typeId=8 then 1 else 0 end) as kk,
')->where($checkWhere)->select();
这里计算的是和,可以用不同的函数计算其他值