正确：

INSERT into t_cities1(city_id,city,province_id) (SELECT city_id,city,province_id from((SELECT * from t_cities where id not in (SELECT id from t_cities1)) as citys))

错误

INSERT into t_cities1(city_id,city,province_id) VALUES((SELECT city_id,city,province_id from((SELECT * from t_cities where id not in (SELECT id from t_cities1)) as citys)))