UPDATE `states` SET `status`=1 where country_id = 13

UPDATE `cities` as city join states state on city.state_id = state.id SET city.`status`=1 where state.country_id = 13