MySQL连接表和计数实例

试试看：

SELECt COUNT(cs.City) as Cities, cn.name as CountryFROM countries cn INNER JOIN country_city cs ON cs.Cntr = cn.id GROUP BY cn.name

输出：

2   | Greece1   | Italy