For Cheryl, drugs have impacted several of her loved ones, including friend and budding footballer John Courtney (pictured), who passed away from a heroin overdose in 2005