“They need people to actually show up in their lives:” deploying community health workers to improve mental health and substance use outcomes among PLWH