actually i am working on a project in which members are added in a tree pattern, and get the payment accordingly.

My tbltestingtree structure is ass follow:
...

the answer is here :

http://stackoverflow.com/questions/1...ee-by-sqlquery...

I am having a table tbltestingtree representing the tree structure, Member_Id is the id of the member, Parent_Id represent the Parentid of that member , Lefts and Rights tells us that the member is attached to the left or right of the Parent.
**My problem is that i have to make a sqlquery that counts the total number of pared members for any particular parent ,**

Ex- currently member with id 1 has 3 pairs with id 2,3 and 4...