The Error "You can't specify target table <tbl> for update in FROM clause" means in the one sql syntax, you cannot select some columns first from one table than update some columns in this table.
In this case, you should select the columns through a temp table to avoid the error.
Example:
delete from tt_users
where user_ID in
(
select temp.user_ID from
(
select user_ID from tt_users temp group by user_ID having count(user_ID) > 1
) <span style="font-family: Arial, Helvetica, sans-serif;">temp</span>
);