1093 – You can’t specify target table ‘table’ for update in FROM clause

The general meaning is that you can’t select some values in the table first, and then update the table (in the same statement)

A temporary table can be introduced for operation

delete from push_ plans WHERE id in  
     select id from  
         select id from push_ plans WHERE   area_ id = 0
     ) as t

Read More: