title: Php mysql Query two usernames in one row based on id from another table
body: <p>I am somewhat new to coding and have been trying to write what I thought would be a straightforward sql query. Please help :)</p>
  
  <pre><code>Table 1: Users
  id = user idt
  username = user name 
  
  Table 2: Orders
  orderid = order id
  order_to = user id of person buying 
  order_from = user id of person selling
  oder_details = text
  </code></pre>
  
  <p>Basically I want to: </p>
  
  <pre><code>"Select Username(from), Username(to), order_details FROM mytables WHERE Order id = 1;" 
  </code></pre>
  
  <p>And get the result as 1 row, I'm not sure how to proceed. I thought I could do this with concatenation or something... Can anyone help?</p>