Do I need to make fixtures for each plate?

Question

Yii

I work with the Yii2 framework, I write unit tests
. There was a question - a dispute, is it necessary to make fixtures for each plate in the database?
The database is very large, and there are many dependencies, in order to make one test, you need to make 10-25 fixtures, it was decided to use fixtures only for dynamic data, such as users, devises, etc.
I remind you that if you make a fixture, then all the data in the plate is deleted.
Not all people liked it, and people began to "drown" for the test database to have all the tables empty, even those with static data (for example, role_users, etc.)
What do you advise and what is the correct and optimal solution?