In essence, everyone pays for federal roads, road user or not, and municipalities pay for local roads. Except for larger state funded projects, which often receive federal assistance. Fuel taxes are a trivial component to infrastructure upkeep, is my understanding.
Another myth is that vehicle registration pays for roads, vehicle registration goes entirely to running the vehicle registration apparatus, that's all.