select
ip.customer, 
ip.ip,
city.id
from statistic_ip as ip left join geo_ip as city on (city.first<ip.ip and city.last>ip.ip)

CREATE TABLE statistic_ip (
  ip int( 10 ) unsigned NOT NULL default '0',
  `load` int( 7 ) NOT NULL default '0',
  uid_site int( 11 ) NOT NULL default '0',
  customer int( 11 ) NOT NULL default '0',
  `date` int( 10 ) NOT NULL default '0',
  PRIMARY KEY  (ip,uid_site,date)
) TYPE=MyISAM;

CREATE TABLE geo_ip (
  id int( 8 ) NOT NULL default '0',
  first int( 11 ) NOT NULL default '0',
  last int( 11 ) NOT NULL default '0',
  KEY first (first),
  KEY last (last),
  KEY firstlast (first,last)
) TYPE=MyISAM;