Behaviour that is rewarded, tends to be repeated. If an overdose that isn't life-threatening gets a reward of increased attention, safety, etc, then certain people will do it again and again and again. Despite the feeling sick, and despite the long-term effects, and despite the impact such behaviour has on friends and family, including when friends and family end up with their own mental health problems as a result of running around and worrying about the overdoser.