How is water absorbed and transported to leaves during night?
By root pressure.
During night, transpiration is very low as the stomata closes and the pull created by transpiration is absent to absorb water. In such a situation, root pressure helps to overcome this problem.