A common delusion. The Constitution is a pact among "the people of the United States," not between the states and the federal government. The preamble was carefully worded.
You're right of course. I always think of it as the States representing the People. Maybe I should have been more particular.