1093 - You can't specify target table 'table' for update in FROM clause

delete from push_plans WHERE id in 
 (
      select id from 
      (
          select id from push_plans WHERE  area_id = 0
          
      ) as t
 )