You can cure the effects of the drugs on sims by waiting it out or doing activities that sober them up. There's also a separate section for curing weed too.