add the city stat and store the data to mysql