get single column values in coma separator in sql server(using COALESC)

DECLARE @Cities nvarchar(max)

select @Cities = coalesce(@Cities + ',', '') + cast(CityId as nvarchar(5))
from Lkp_Cities where IsActive=1 and IsDeleted=0

select @Cities as Cities