上级查所有下级

function tudui($id,$type)
{
    $user1 = Db::name('user')->where('first_leader',$id)->column('id');
    $namesString1 = implode(',', $user1);
    
    $shu1 = Db::name('account_log')->where('user_id','in',$namesString1)->where('source_type',$type)->sum('change_amount'); 
    $shu2 = 0;
    if(!empty($namesString1)){
	    do{   
    		$user2 = Db::name('user')->where('first_leader','in',$namesString1)->column('id');
    		$namesString2 = implode(',', $user2);
    		unset($namesString1);
            
            $shu2 += Db::name('account_log')->where('user_id','in',$namesString2)->where('source_type',$type)->sum('change_amount'); 
            
    		$namesString1 = $namesString2;
	    }while(!empty($namesString1));
        $shu = $shu1 + $shu2;
    
        return $shu;
    
    }else{
        return 0;
    }
}