How can this be converted into code?

For example, the amount of RMB 100 should be evenly distributed to many people, with a level of RMB 15% above, 20% RMB 20% above, 15% RMB 15% above, and 5% RMB 5% above.

For example, the amount of RMB 100 should be evenly distributed to many people, with a level of RMB 15% above, 20% RMB 20% above, 15% RMB 15% above, and 5% RMB 5% above.

Reply content:

For example, the amount of RMB 100 should be evenly distributed to many people, with a level of RMB 15% above, 20% RMB 20% above, 15% RMB 15% above, and 5% RMB 5% above.

That's what I think.

The company ID, company name, and parent company ID are similar to tree menus.

For example, company ID = 15, company name = 3D code technology, parent company ID = 17
First write an algorithm, first level 1 up to find, form a tree menu, the top, parent level ID = 0

In this way, revenue can be allocated.

You want code + table design! I still want to think about it!

Unlimited table design
The code logic follows Level 1, Level 2, and Level 3 ..... Percentage of categories