我的

SELECT SUM(IF(d.status=1,1,0)) '空闲', SUM(IF(d.status=3,1,0)) '运行', SUM(IF(d.status=4,1,0)) '故障', SUM