Install this plugin https://wordpress.org/plugins/delete-me/ and it will automatically show such option in My Profile page