insert into w_zone (warehouse_id,zone_code)SELECT warehouse_id ,zone_code from w_seat WHERE warehouse_id = 1 GROUP BY zone_code