Delete from two tables in one query (ok)

DELETE user, user_join FROM user INNER JOIN user_join WHERE user.id = user_join.user_id;