Hello Joy,

When they edit their profile, they will be able to see a delete button to delete their own profile. This is also provided that in the profile type settings, you allow users to delete their own profile, http://take.ms/83AWS