better light help

hi. im trying to make a night scene in my game and i made some lightposts they have a spot light pointing towards the ground. like in real life i want the light to be kinda foggy so you can see it as it comes to hit the ground.

if you could look at this image

are there any ways i can replicate the effects in this image?

Yup, volume fog:

If you just put exponential height fog in the scene and tick ‘volumetric’ in the details, that might be enough. Or you may need to do some extra tweaking…