SELECT 
     `geoip_city`.`name`, 
     COUNT(`statistic`.`city_id`) AS `total` 
FROM `statistic` 
INNER JOIN `geoip_city` ON (`statistic`.`city_id` = `geoip_city`.`id`) 
GROUP BY `statistic`.`city_id`;

SELECT `geoip_city`.`name`, sq.total total
FROM `geoip_city`,
(SELECT `statistic`.`city_id`, COUNT(*) AS `total`
FROM `statistic`
GROUP BY `statistic`.`city_id`
) sq
WHERE sq.`city_id` = `geoip_city`.`id`;