/*
* 获取所有下级
* @param $id String 待查找的id
* @return String | NULL 失败返回null
*/
function getSub($ids,$friendsGroupID)
{
$isComma = strstr($ids,',');
$res = DBManager::getMysql()->selectAll(MysqlConfig::Table_web_club_member, ['userID'], "friendsGroupID=".$friendsGroupID." and inviter_userid in (".$ids.')'); //获取二维数组,如Array ( [0] => Array ( [id] => 12 ) [1] => Array ( [id] => 13 ) )
if ($res) {
$userIDs = '';
foreach ($res as $k=>$v) {
if($v['userID']>0){
if($k == 0){
$userIDs = $v['userID'];
}else{
$userIDs .= ','.$v['userID'];
}
}
}
if($isComma){
$ids .= "," . $userIDs;
}else{
$ids = $ids.',';
$ids .= $userIDs.',';
}
// var_dump($ids);
// die;
$ids .= $this->getSub($ids,$friendsGroupID);
}
return $ids;
}