为方便项目使用，特留！
表结构：
CREATE TABLE `location` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`fId` bigint(20) default NULL,
`language` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fId` (`fId`),
CONSTRAINT `location_fk` FOREIGN KEY (`fId`) REFERENCES `location` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8
数据：
insert into location (id,name,fid,language) values(1,'中国',null,0);
insert into location (id,name,fid,language) values(2,'北京',1,0);
insert into location (id,name,fid,language) values(3,'北京',2,0);
insert into location (id,name,fid,language) values(4,'上海',1,0);
insert into location (id,name,fid,language) values(5,'上海',4,0);
insert into location (id,name,fid,language) values(6,'香港特别行政区',1,0);
insert into location (id,name,fid,language) values(7,'香港特别行政区',6,0);
insert into location (id,name,fid,language) values(8,'澳门特别行政区',1,0);
insert into location (id,name,fid,language) values(9,'澳门特别行政区',8,0);
insert into location (id,name,fid,language) values(10,'河北',1,0);
insert into location (id,name,fid,language) values(11,'石家庄',10,0);
insert into location (id,name,fid,language) values(12,'唐山',10,0);
insert into location (id,name,fid,language) values(13,'保定',10,0);
insert into location (id,name,fid,language) values(14,'衡水',10,0);
insert into location (id,name,fid,language) values(15,'秦皇岛',10,0);
insert into location (id,name,fid,language) values(16,'邯郸',10,0);
insert into location (id,name,fid,language) values(17,'邢台',10,0);
insert into location (id,name,fid,language) values(18,'保定',10,0);
insert into location (id,name,fid,language) values(19,'张家口',10,0);
insert into location (id,name,fid,language) values(20,'承德',10,0);
insert into location (id,name,fid,language) values(21,'沧州',10,0);
insert into location (id,name,fid,language) values(22,'廊坊',10,0);
insert into location (id,name,fid,language) values(23,'山西',1,0);
insert into location (id,name,fid,language) values(24,'太原',23,0);
insert into location (id,name,fid,language) values(25,'大同',23,0);
insert into location (id,name,fid,language) values(26,'阳泉',23,0);
insert into location (id,name,fid,language) values(27,'长治',23,0);
insert into location (id,name,fid,language) values(28,'晋城',23,0);
insert into location (id,name,fid,language) values(29,'吕梁',23,0);
insert into location (id,name,fid,language) values(30,'晋中',23,0);
insert into location (id,name,fid,language) values(31,'运城',23,0);
insert into location (id,name,fid,language) values(32,'临汾',23,0);
insert into location (id,name,fid,language) values(33,'朔州',23,0);
insert into location (id,name,fid,language) values(34,'忻州',23,0);
insert into location (id,name,fid,language) values(35,'辽宁',1,0);
insert into location (id,name,fid,language) values(36,'沈阳',35,0);
insert into location (id,name,fid,language) values(37,'大连',35,0);
insert into location (id,name,fid,language) values(38,'鞍山',35,0);
insert into location (id,name,fid,language) values(39,'抚顺',35,0);
insert into location (id,name,fid,language) values(40,'本溪',35,0);
insert into location (id,name,fid,language) values(41,'丹东',35,0);
insert into location (id,name,fid,language) values(42,'锦州',35,0);
insert into location (id,name,fid,language) values(43,'葫芦岛',35,0);
insert into location (id,name,fid,language) values(44,'营口',35,0);
insert into location (id,name,fid,language) values(45,'盘锦',35,0);
insert into location (id,name,fid,language) values(46,'阜新',35,0);
insert into location (id,name,fid,language) values(47,'朝阳',35,0);
insert into location (id,name,fid,language) values(48,'辽阳',35,0);
insert into location (id,name,fid,language) values(49,'铁岭',35,0);
insert into location (id,name,fid,language) values(50,'吉林',1,0);
insert into location (id,name,fid,language) values(51,'长春',50,0);
insert into location (id,name,fid,language) values(52,'四平',50,0);
insert into location (id,name,fid,language) values(53,'辽源',50,0);
insert into location (id,name,fid,language) values(54,'通化',50,0);
insert into location (id,name,fid,language) values(55,'白山',50,0);
insert into location (id,name,fid,language) values(56,'松原',50,0);
insert into location (id,name,fid,language) values(57,'白城',50,0);
insert into location (id,name,fid,language) values(58,'延边朝鲜族自治州',50,0);
insert into location (id,name,fid,language) values(59,'吉林',50,0);
insert into location (id,name,fid,language) values(60,'黑龙江',1,0);
insert into location (id,name,fid,language) values(61,'哈尔滨',60,0);
insert into location (id,name,fid,language) values(62,'齐齐哈尔',60,0);
insert into location (id,name,fid,language) values(63,'鹤 岗',60,0);
insert into location (id,name,fid,language) values(64,'双鸭山',60,0);
insert into location (id,name,fid,language) values(65,'鸡 西 ',60,0);
insert into location (id,name,fid,language) values(66,'大 庆',60,0);
insert into location (id,name,fid,language) values(67,'伊 春',60,0);
insert into location (id,name,fid,language) values(68,'牡丹江',60,0);
insert into location (id,name,fid,language) values(69,'佳木斯',60,0);
insert into location (id,name,fid,language) values(70,'七台河',60,0);
insert into location (id,name,fid,language) values(71,'黑 河',60,0);
insert into location (id,name,fid,language) values(72,'绥 化',60,0);
insert into location (id,name,fid,language) values(73,'大兴安岭地区',60,0);
insert into location (id,name,fid,language) values(74,'江苏',1,0);
insert into location (id,name,fid,language) values(75,'南京',74,0);
insert into location (id,name,fid,language) values(76,'南通',74,0);
insert into location (id,name,fid,language) values(77,'苏州',74,0);
insert into location (id,name,fid,language) values(78,'扬州',74,0);
insert into location (id,name,fid,language) values(79,'无锡',74,0);
insert into location (id,name,fid,language) values(80,'常州',74,0);
insert into location (id,name,fid,language) values(81,'淮安',74,0);
insert into location (id,name,fid,language) values(82,'盐城',74,0);
insert into location (id,name,fid,language) values(83,'宿迁',74,0);
insert into location (id,name,fid,language) values(84,'徐州',74,0);
insert into location (id,name,fid,language) values(85,'连云港',74,0);
insert into location (id,name,fid,language) values(86,'镇江',74,0);
insert into location (id,name,fid,language) values(87,'泰州',74,0);
insert into location (id,name,fid,language) values(88,'浙江',1,0);
insert into location (id,name,fid,language) values(89,'杭州',88,0);
insert into location (id,name,fid,language) values(90,'宁波',88,0);
insert into location (id,name,fid,language) values(91,'嘉兴',88,0);
insert into location (id,name,fid,language) values(92,'绍兴',88,0);
insert into location (id,name,fid,language) values(93,'温州',88,0);
insert into location (id,name,fid,language) values(94,'义乌',88,0);
insert into location (id,name,fid,language) values(95,'金华',88,0);
insert into location (id,name,fid,language) values(96,'舟山',88,0);
insert into location (id,name,fid,language) values(97,'湖州',88,0);
insert into location (id,name,fid,language) values(98,'衢州',88,0);
insert into location (id,name,fid,language) values(99,'台州',88,0);
insert into location (id,name,fid,language) values(100,'丽水',88,0);
insert into location (id,name,fid,language) values(101,'安徽',1,0);
insert into location (id,name,fid,language) values(102,'合肥',101,0);
insert into location (id,name,fid,language) values(103,'淮南',101,0);
insert into location (id,name,fid,language) values(104,'马鞍山',101,0);
insert into location (id,name,fid,language) values(105,'淮北',101,0);
insert into location (id,name,fid,language) values(106,'安庆',101,0);
insert into location (id,name,fid,language) values(107,'黄山',101,0);
insert into location (id,name,fid,language) values(108,'阜阳',101,0);
insert into location (id,name,fid,language) values(109,'宿州',101,0);
insert into location (id,name,fid,language) values(110,'六安',101,0);
insert into location (id,name,fid,language) values(111,'毫州',101,0);
insert into location (id,name,fid,language) values(112,'池州',101,0);
insert into location (id,name,fid,language) values(113,'宣城',101,0);
insert into location (id,name,fid,language) values(114,'巢湖',101,0);
insert into location (id,name,fid,language) values(115,'芜湖',101,0);
insert into location (id,name,fid,language) values(116,'蚌埠',101,0);
insert into location (id,name,fid,language) values(117,'铜陵',101,0);
insert into location (id,name,fid,language) values(118,'滁州',101,0);
insert into location (id,name,fid,language) values(119,'福建',1,0);
insert into location (id,name,fid,language) values(120,'福州',119,0);
insert into location (id,name,fid,language) values(121,'厦门',119,0);
insert into location (id,name,fid,language) values(122,'泉州',119,0);
insert into location (id,name,fid,language) values(123,'漳州',119,0);
insert into location (id,name,fid,language) values(124,'三明',119,0);
insert into location (id,name,fid,language) values(125,'莆田',119,0);
insert into location (id,name,fid,language) values(126,'宁德',119,0);
insert into location (id,name,fid,language) values(127,'南平',119,0);
insert into location (id,name,fid,language) values(128,'龙岩',119,0);
insert into location (id,name,fid,language) values(129,'江西',1,0);
insert into location (id,name,fid,language) values(130,'南昌',129,0);
insert into location (id,name,fid,language) values(131,'新余',129,0);
insert into location (id,name,fid,language) values(132,'庐山',129,0);
insert into location (id,name,fid,language) values(133,'景德镇',129,0);
insert into location (id,name,fid,language) values(134,'萍乡',129,0);
insert into location (id,name,fid,language) values(135,'九江',129,0);
insert into location (id,name,fid,language) values(136,'鹰潭',129,0);
insert into location (id,name,fid,language) values(137,'赣州',129,0);
insert into location (id,name,fid,language) values(138,'吉安',129,0);
insert into location (id,name,fid,language) values(139,'宜春',129,0);
insert into location (id,name,fid,language) values(140,'抚州',129,0);
insert into location (id,name,fid,language) values(141,'上饶',129,0);
insert into location (id,name,fid,language) values(142,'山东',1,0);
insert into location (id,name,fid,language) values(143,'济南',142,0);
insert into location (id,name,fid,language) values(144,'青岛',142,0);
insert into location (id,name,fid,language) values(145,'淄博',142,0);
insert into location (id,name,fid,language) values(146,'枣庄',142,0);
insert into location (id,name,fid,language) values(147,'东营',142,0);
insert into location (id,name,fid,language) values(148,'烟台',142,0);
insert