mysql数据库两表关联查询统计同一字段不同值的个数

统计总数

SELECT h.*,IFNULL(count(r.pid),0) AS 总数 FROM rts_room AS r RIGHT JOIN rts_house AS h ON r.pid = h.Id AND r.state != 3 WHERE h.state = 0 GROUP BY h.Id