How to create a YII2 sitemap?

Question

Yii

There is a site, it has:
level1, level2, level2 mods, level0
At the same time, the url is possible as:
level1 + level0
, level1 + level2, level1 + level2 + level2 mods, level1 + level2 + level2 mods + level0, level1 + level2 + level0, level1 has a many-to-many relationship with level2, level2 with the mods of level2, level1 and level0. If you collect url in a loop, then I run into a timeout. Runs approximately: level0: 11 pieces mods Level2: 43464 pieces level2 : 731 pieces level1: 3 pieces 11 * 43464 * 731 * 3 = 1048482072 iterations

Answer 1

and what do you do?

Answer 2

manually download the database, and through the editor (for example, notepad ++) using search and replace, substitute the code, the easiest way