DELETE
FROM (`users`)
WHERE `user_id` IN (SELECT `user_id` FROM `users` WHERE `referrals` = `super_user_id`)
AND `status` = '1'