使用IN条件mysqli删除多行

I query a database and save the results into an array. I want to delete rows from database that match the results in said array. I also have to drop a few tables that also share same name as the values stored in the array. Which is why I'm doing a SELECT statement first and not just DELETEI query a database and save the results into an