对于无限极下级以及下三级总量的问题

首先注册时：
function register()
{
$param=$this->request->param();
$phone = $param[‘phone’];
$password = $param[‘password’];
$verification_code = $param[‘code’];//验证码
$parent = $param{[}^{\prime }paren{t}_i{d}^{\prime }];//上级的id作为邀请码if(!Str::i{s}_{v}ali{d}_{p}hone($phone) ) {
return return_json([],400, “手机号格式错误” );
}
if (!Str::is_valid_register_pass($password))returnretur{n}_{j}son([],400,"密码为6-16位数字、字母、下划线组合");if(!User::get($parent) ){
return return_json([],400, “邀请码不存在” );
}
if (!$this->re{g}_{n}um($parent)){
return return_json([],400, “该邀请码已超过当日邀请上限” );
}
$reward=Db::name(‘config’)->where(‘name’,‘reg_award’)->value(‘value’);
$user = new User;
Db::startTrans();
try {
$sms=newSmsService($phone);
$sms->check($verification_code);
$password=Rsa::decrypt($password);
$user->add( $phone, $password,$parent,$reward);if($reward>0)
Db::name(‘reward_log’)->insert([‘uid’=>$user->id{,}^{\prime }chang{e}_{n}u{m}^{\prime }=>$reward,‘flag’=>11,‘time’=>time()]);
}
Db::commit();
} catch (\Exception $e) {
Db::rollback();
return return_json ( [], 400, $e->getMessage());
}

    return $this->returnSuccess([],'注册成功');
}
添加上级

function add($account, $pass, $parent=0,$reward=0)
{
$RechargeBusiness=newRechargeBusiness();//$account = preg_replace($pattern, $replacement, $subject);
$user = User::get([‘phone’ => $account]);if(!$user) {
$this->data([
‘phone’ => $account{,}^{\prime }re{g}_{t}im{e}^{\prime }=>time(){,}^{\prime }passwor{d}^{\prime }=>jiami($pass),
‘path’ =>$RechargeBusiness->registe{r}_{p}ath($parent),
‘pid’=>$parent{,}^{\prime }bti{t}_{p}oo{l}^{\prime }=>$reward,
‘avatar’=>’/static/admin/images/20190222.png’
]);
} else {
throw new \Exception(‘账户已存在’);
}
$this->save();
// $this->coininit($this[‘id’]);
//$this->initOtherTable($user);
return $this;
}
//拼接注册用户的path字段
//@ $pid:注册时的邀请idfunctionregiste{r}_{p}ath($pid){
$path=Db::name{(}^{\prime }use{r}^{\prime })->where{(}^{\prime }i{d}^{\prime },$pid)->value(‘path’).’,’.$pid;
return $path;
}
以上操作就是用户注册时需要传pid也就是父id

以下时获取下三级以及无限级的方法
/**

• 根据id获取 三代的下级id
• @param $id\ast /functionge{t}_{c}hild($id=’’){
  $chil{d}_{o}ne=Db::name{(}^{\prime }use{r}^{\prime })->where{(}^{\prime }i{d}^{\prime }{,}^{\prime }<{>}^{\prime },1)->where{(}^{\prime }pi{d}^{\prime },$id)->column(‘id’);
  $chil{d}_{t}wo=Db::name{(}^{\prime }use{r}^{\prime })->where{(}^{\prime }i{d}^{\prime }{,}^{\prime }<{>}^{\prime },1)->whereIn{(}^{\prime }pi{d}^{\prime },$child_one)->column(‘id’);
  $chil{d}_{t}hree=Db::name{(}^{\prime }use{r}^{\prime })->where{(}^{\prime }i{d}^{\prime }{,}^{\prime }<{>}^{\prime },1)->whereIn{(}^{\prime }pi{d}^{\prime },$child_two)->column(‘id’);
  $ids=arra{y}_{m}erg{e}_{r}ecursive($child_one,$chil{d}_{t}wo,$child_three);
  return $ids;
  }

/**

• 根据id获取 无限代的下级id
• @param $id\ast /functionge{t}_{c}hild2($id=’’){
  $path=Db::name("user")->where("id",$id)->value(“path”);
  $path = $path.",".$id;
  $ids=Db::name("user")->where("path",$path)->whereOr(“path”,“like”,$path.",%")->column(“id”);
  return $ids;
  }

$tota{l}_{p}erson=Db::name{(}^{\prime }use{r}^{\prime })->where{(}^{\prime }i{d}^{\prime }{,}^{\prime }i{n}^{\prime },$ids)->count();