Multi level Commission

I’ve been asked to create a CRM for sales with multilevel commission.
First level - Carlos recommends Mario and signs up for service. Carlos gets $25.00.
Second Level - Mario recommends Maria and signs up for service. Mario gets $25.00, Carlos gets $10.00.
Third Level - Maria recommends Susane and signs up for service, Maria gets $25.00. Mario gets $10.00 and Carlos gets $5.00.
Only 3 levers are necessary, if Susane recommends Tom, Susane gets, $25.00, Maria gets $10.00, and Mario gets $5.00. Carlos is out of the loop.
Hopefully someone can help me with this puzzle. I don’t even know where to start and designs the database structure.

Upon careful analysis, it’s actually not that hard.

You need a table/grid with an add form like this:

Recommendations is a many to many connection to itself:

Count is a count of the connections for a given record:

And Commission is a currency field with some validation rules like this:

Comm val 2

The grid is editable in my case. You just add the names of those who are granted under the particular person’s name. It’s a little redundant but it works perfectly.