How do cocaine users get hole in nose?

Vasoconstriction. Cocaine constricts the blood supply and over time tissue dies from lack of blood and thus a hole develops.