title: Having trouble creating a Laravel query
body: <p>I'm trying to create a form select box in Laravel 4.</p>
  
  <p>There are 3 models in play: User, Band, and Album.</p>
  
  <p>I have the eloquent relationships set up and working as follows:</p>
  
  <ul>
  <li>A User hasMany Band</li>
  <li>A Band hasMany User</li>
  <li>A Band hasMany Album</li>
  <li>An Album belongsTo a Band</li>
  </ul>
  
  <p>How do I create an array $albums:</p>
  
  <pre><code>$userid = Auth::user()-&gt;id;
  $albums = Album::where(the band the album belongs to has a user with id = $userid);
  </code></pre>
  
  <p>I can't seem to figure this out. </p>
  
  <p>Should I instead create a many-to-many relationship between albums and users, so I can construct an easier query such as $albums = $user->albums;</p>
  
  <p>I'd prefer not having to create another many-to-many relationship, as that's a whole new level of DB management to clutter things up.</p>
  
  <p>Thanks for your assistance!
  ~Ross</p>