Yes the moon affects the water in tides, so it's gravitational pull also affects the water in our bodies.

Have you heard of lunatic? That is when there's a stronger pull from the moon affecting the water in our bodies and hence our minds.