title: Laravel - Get users with their roles name
body: <p>I need to get my users with their roles (to list, not to check!) on standard Auth system.<br>
  I do somethink like this:  </p>
  
  <pre><code>$users = DB::table('users')
              -&gt;join( 'user_roles', 'users.id', '=', 'user_roles.user_id' )
              -&gt;select('id', 'first_name', 'role_id')
              -&gt;get();
  </code></pre>
  
  <p>And I getting this:</p>
  
  <pre><code>array:2 [▼
    0 =&gt; {#552 ▼
      +"id": 9670
      +"first_name": "Paweł"
      +"role_id": 1337
    }
    1 =&gt; {#553 ▼
      +"id": 9670
      +"first_name": "Paweł"
      +"role_id": 100
    }
  ]
  </code></pre>
  
  <p>But I need this:</p>
  
  <pre><code>array:2 [▼
    0 =&gt; {#552 ▼
      +"id": 9670
      +"first_name": "Paweł"
      +"roles": 'Admin, AnotherRole'
    }
  ]
  </code></pre>
  
  <p>How can I do this?
  Structures of my tables:<br>
  <strong>users</strong><br>
  'id'
  'firstname'
  ... etc.<br>
  <strong>roles</strong><br>
  'id'
  'name'<br>
  <strong>user_roles</strong><br>
  'user_id'
  'role_id'</p>