Install this plugin https://wordpress.org/plugins/delete-me/ and in Settings → Delete Me enable user roles that will be able to delete their account. “Delete” button will automatically show in My Profile page