Laravel multilevel marketing database

am trying to build a multi level marketing site. I have everything in place. Trying to query my database for three levels deep referrals. Here is my code.

public function matrix()
{        
    $referrals = DB::table('users')->where('referred_by', Auth::user()->referral_id)->get();
    if ($referrals) {
        return view('matrix2', ['referrals' => $referrals]);
        $referrals2gen = DB::table('users')->where('referred_by',$referrals[0]->referral_id)->get();
            if ($referrals && $referrals2gen) {
            return view('matrix3', ['referrals' => $referrals, 'referrals2gen' => $referrals2gen]);
            $referrals3gen = DB::table('users')->where('referred_by',$referrals2gen[0]->referral_id)->get();
                if ($referrals && $referrals2gen && $referrals3gen) {
                return view('matrix4', ['referrals' => $referrals, 'referrals2gen' => $referrals2gen, 'referrals3gen' => $referrals3gen]); 
                }
        }
    }
    else
    {
         return view('matrix');
    }  

it only displays the first referrals. Please how can i do it better?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2wlV3dA
via IFTTT