我正在尝试获取指定上线下所有用户的列表。例如,上线 id 1 的下线为 (2,3,4,5,6)
我的桌子看起来像这样。
+----------------------+-----+------+
| line_id | upline_id| downline_id| main_upline_id|
+----------------------+-----+------+
| 1 | 0 | 1 | 0 |
| 2 | 1 | 2 | 1 |
| 3 | 2 | 3 | 1 |
| 4 | 3 | 4 | 1 |
| 5 | 1 | 5 | 1 |
| 6 | 5 | 6 | 1 |
| 7 | 0 | 7 | 0 |
| 8 | 7 | 8 | 7 |
| 9 | 8 | 9 | 7 |
| 10 | 9 | 10 | 7 |
+----------------------+-----+------+
还有我的代码
public function downline($id, $array) {
$lineModel = CLONEAPI::getModel( 'line' );
$data = $lineModel->getAllById($id);
if (sizeof($data) != 0 )
{
foreach ($data as $child)
{
$array[] = $child;
// How do i rerun the loop until no more downline ids are found without writing a bunch of foreach loops?
}
}
}
我如何编写递归函数来获取所有相关的下线 ID?
呼啦一阵风
慕哥6287543