How is water absorbed and transported to leaves during the night?
By root pressure.
During the night, transpiration is very low as the stomata close and the pull created by transpiration is absent to absorb water. In such a situation, root pressure helps to overcome this problem. Root pressure is caused by this accumulation of water in the xylem pushing on the rigid cells.