#  Delete all orphans user meta in WordPress
DELETE FROM wp_usermeta
WHERE NOT EXISTS (
  SELECT * FROM wp_users
	WHERE wp_usermeta.user_id = wp_users.ID
);

# Remove multisite only columns in users
alter table wp_users drop column spam;
alter table wp_users drop column deleted;