Answer
Yes, people are heavier at midnight than at noon.
Work Step by Step
At noon, the sun’s gravitational attraction on you is upward, and partially cancels the gravitational force from the Earth. The effect is tiny.
At midnight, the two forces pull together. The net effect is to increase your apparent weight at midnight.