title: Recursive mysql select?
body: <p>I saw <a href="https://stackoverflow.com/a/13186486/34537">this answer</a> and i hope he is incorrect, just like someone was incorrect telling primary keys are on a column and I can't set it on multiple columns.</p>
  
  <p>Here is my table</p>
  
  <pre><code>create table Users(id INT primary key AUTO_INCREMENT,
      parent INT,
      name TEXT NOT NULL,
      FOREIGN KEY(parent)
      REFERENCES Users(id)
  );
  
  
  +----+--------+---------+
  | id | parent | name    |
  +----+--------+---------+
  |  1 |   NULL | root    |
  |  2 |      1 | one     |
  |  3 |      1 | 1down   |
  |  4 |      2 | one_a   |
  |  5 |      4 | one_a_b |
  +----+--------+---------+
  </code></pre>
  
  <p>I'd like to select user id 2 and recurse so I get all its direct and indirect child (so id 4 and 5).</p>
  
  <p>How do I write it in such a way this will work? I seen recursion in postgresql and sqlserver. </p>