title: Display data from left join query [Laravel 5]
body: <p>stackers
  I'm facing a problem on displaying data from query that contain join statement.</p>
  
  <pre><code>public function view(Request $id)
  {
      $user_id = $id-&gt;input('id');
      $users = DB::table('users')-&gt;select('*')
                  -&gt;leftjoin('role_user', 'users.id', '=', 'role_user.user_id')
                  -&gt;leftjoin('roles', 'roles.id', '=', 'role_user.role_id')
                  -&gt;where('users.id', '=', $user_id)-&gt;get();
      return view('/admin/view_user', ['users' =&gt; $users]);
  }
  </code></pre>
  
  <p>From the above code, how do i display the row and the join table data from roles, and role_user</p>