Lamento que usted no pueda acompañarnos.

[waxapax]

English Translation

I’m sorry that you can’t join us.

I expected unarnos or reunirnos, I think it could be better translated as accompany us.