Iam new to cakephp and i need some help.
I have 2 columns in a table, agentid and sponsorid.
I need to calculate commission, if a agent has a sponsorid and this is considered as Level1.
If Level1 sponsor has a sponsorid, then this is considered as level2.
If Level2 sponsor has a sponsorid, then this is considered as level3.
Similarly i need to find for 6 levels to calculate the commission.
The commission varies for each level.

Ex:
agentid => sponsorid
75=>100,
42=>75,
90=>42,
37=>90,
25=>37,
10=>25

Thanks in advance,