DELETE orphan_table FROM orphan_table
LEFT JOIN user_table
ON orphan_table.user_id = user_table.id
WHERE user_table.id IS NULL;