title: How do I output a multidimensional array from multiple relational MySQL tables?
body: <p>I have three tables: Event, Events and Users. The Event table stores information relevant to a specific event (name, date, etc), the Users table stores user information (name, age, etc) and the Events table is the relational between the two, storing only Event_ID and User_ID.</p>
  
  <p>I need to list out all the events for a specific user (lets say User_ID = 20), and show all the other users who are also in that event below each.</p>
  
  <p>For example, lets say the user is going to "Steve's Birthday", "Homecoming Party" and "Art Show Downtown". I'd need to display:</p>
  
  <p>Steve's Birthday - Also going: Sarah, Mike, Tom
  Homecoming Party - Also going: Mike, Andy, Roger, Steve
  Art Show Downtown - Also going: Sarah</p>
  
  <p>I've tried querying the database first to find all Event_ID's in the Events table that match the User_ID. Then I take that array, and for each find the event_name and event_date. But I'm confusing myself way too much trying to figure out how to then find each person also going to that event. </p>
  
  <p>Can anyone understand what I'm trying to do and suggest a method to pull it off?</p>