php mysql 获取 某个会员的无限上级

//获取某个会员的无限上级方法  是否代理：0否  1是
public function GetSuperiorMember($mid, $SuperiorTeam)
{
    $member = Db::name('member')->where(['member_id' => $mid])->field('member_id,source_member')->find();
    if ($member['source_member'] > 1) {
        $superior = Db::name('member')->where(['member_id' => $member['source_member']])->field('member_id,source_member,is_agent')->find();
        if ($superior['is_agent'] == 1){
            $SuperiorTeam[] = $superior;
        }
        return $this->GetSuperiorMember($superior['member_id'], $SuperiorTeam);
    }
    return $SuperiorTeam;
}

//获取某个会员的无限上级方法  是否代理：0否  1是 (全官方代理)
public function GetSuperiorMember_new($mid, $SuperiorTeam)
{
    $member = Db::query("select a.member_id,a.source_member,a.is_agent,b.level_id,b.agent_stars_num from member a left join agent b on a.member_id = b.member_id where a.member_id = $mid");
    if($member){
        $member = $member[0];
        if ($member['source_member'] > 1) {
            //$superior = Db::name('member')->where(['member_id' => $member['source_member']])->field('member_id,source_member,is_agent')->find();
            $superior = Db::query("select a.member_id,a.source_member,a.is_agent,b.level_id,b.agent_stars_num from member a left join agent b on a.member_id = b.member_id where a.member_id = ".$member['source_member']);
            if($superior){
                $superior = $superior[0];
                if ($superior['is_agent'] == 1 && $superior['level_id'] == 1){
                    $SuperiorTeam[] = $superior;
                }
            }
            return $this->GetSuperiorMember_new($superior['member_id'], $SuperiorTeam);
        }
    }
    return $SuperiorTeam;
}