MySQL报 You can't specify target table 'c' for update in FROM clause

上述报错的语句，比如我执行如下MySQL，则报错：

UPDATE station c SET c.status=2 WHERE c.id IN (
SELECT
	a.id
FROM
	station a
LEFT JOIN station_application_record b ON a.station_num = b.station_num
WHERE
	b.bill_num = 'GO1803150000431');UPDATE station c SE