title: Inner join in php redbeans
body: <p>I have following structure</p>
  
  <pre><code>USER
   user_id
   name
  
  EVENT
   event_id
   user_id
   event_name
  </code></pre>
  
  <p>How can I write inner join in redbean?</p>
  
  <pre><code>SELECT * FROM event e join user u on u.user_id = e.user_id 
  </code></pre>
  
  <p>also how can I change Primary key of table schema in redbeans </p>