how to use many fixtures for one table?

I am not all that happy with fixtures as they are at the DB level and
not the model level. You need to get IDs right between files etc.

Have you tried just creating a different YML file in the fixtures
directory, then splitting your tests into separate classes that
reference the different fixtures?

I do not know if this will work, but I would expect it to.