MySQL获取某一列的不同值的个数

$count=db('meter_yj_message')->where('read',0)->where('type',3)->field('equip_id')->count('distinct equip_id');
//sql语句
select count( distinct equip_id) from VALUE_METER_YJ_MESSAGE where [read] = 0