mysql通过查询并且执行删除关联数据

delete from us_account where userId in (select userId from (SELECT u.userId from us_user u where u.mobile in (18620384332,13590195718,18173102103,13428790860,18926567008,15002059895,15822304763))a)