PHP How to cycle query member recommendations, as well as to the member points, direct relationship 5 points, indirect relationship 1 points, ask you to help solve.

Table field is like this, query direct relationship is OK

$sql = "SELECT count (*) as Count from User_relation WHERE formid= '". $id. "'"; $query =mysql_query ($sql), if ($rs =mysql_fetch_array ($query)) {    $count = $rs [0];} else{    $count = 0;}

But how to deal with the indirect relationship, the top is fid=0. For example, I am 2203 that ID, the following direct relationship has 2204, 2207, 2206 and so on, and then the indirect relationship is 2204 below the 2210, 2208 and so on, how to find out a member of the following all direct recommendations and indirect recommendations, and accumulate it. Brother Small white, please God help.

Reply to discussion (solution)

No one ... Ask for help ...

One layer at a cover.
Study name recursion

No one ... Ask for help ...

Alas, for a day, a little clue is not, ask the big God answer

