select city.name,area.name,count(info.id) from cityleft join area on area.cityid = city.cityidleft join info on info.areaid = area.areaidwhere city.name = '北京市' group by city.name,area.name
大概意思.字段名称根据你的具体表结构替换一下
