获取所有下级的id

方式1：递归

function getSubs($id, $includeSelf = true){
    static $ids = [];
    if($includeSelf) {
        if(!in_array($id, $ids)) {
            array_push($ids, $id);
        }
    }
    $subIds = M('user')
        ->field('user_id')
        ->select();
    $subIds = array_column($subIds, 'user_id');
    $ids = array_unique(array_merge($ids, $subIds));
    foreach($subIds as $sub_id) {
        getSubs($sub_id, $includeSelf);
    }

    return $ids;
}

方式2：循环

function getSubIds($userID, $includeSelf = true){
    $userIDs = [$userID];
    while (true) {
        $subIDs = M('user')
            ->field('user_id')
            ->where(['pid' => ['IN', $userIDs]])
            ->select();
        $subIDs = array_column($subIDs, 'user_id');
        $userCount = count($userIDs);
        $userIDs = array_unique(array_merge($userIDs, $subIDs));
        if ($userCount == count($userIDs)) {
            break;
        }
    }
    if (!$includeSelf) {
        for ($i = 0; $i < count($userIDs); ++$i) {
            if ($userIDs[$i] == $userID) {
                array_splice($userIDs, $i, 1);
                break;
            }
        }
    }

    return $userIDs;
}