title: Select users with a certain role in Kohana's auth module
body: <p>In the auth module, we have users and roles with a many to many relationship.</p>
  
  <p>My question probably has a simple answer, but I couldn't find it by myself... How would I go about selecting only users having a certain role using ORM?
  What I'd like to do is something like this:</p>
  
  <pre><code>ORM::factory('user')-&gt;with('roles')-&gt;where('role','member')-&gt;find_all();
  </code></pre>
  
  <p>but that does not work...</p>
  
  <p>Thank you</p>