Think of it like this:
* The Sun is like a giant light bulb.
* The Earth is like a spinning ball.
When one side of the Earth faces the Sun, it's daytime. When that side rotates away from the Sun, it's nighttime.
So, to answer your question directly, the Sun is still in the same place when it's nighttime on Earth. It's just that the part of the Earth where it's nighttime is facing away from the Sun.