title: CakePHP self-join a HABTM table without breaking Cake's automation
body: <p>I have a table of athletes.  Athletes have coaches, who are also athletes.  Athletes may have multiple coaches. </p>
  
  <p>To handle this, I have created an athletes table, that uses a join table with an id field, and athlete_id field, and a coach_id field.  Both the athlete_id and coach_id fields point back to the athletes table to the id field.</p>
  
  <p>Normally, according to Cake conventions, I would have to name both of my fields athlete_id, but I have found the following link that shows how to handle that:  <a href="http://book.cakephp.org/1.2/view/851/Multiple-relations-to-the-same-model" rel="nofollow">http://book.cakephp.org/1.2/view/851/Multiple-relations-to-the-same-model</a></p>
  
  <p>According to Cake conventions, I would name my join table athletes_athletes, but I'm not sure that will function correctly?  It seems like it might make sense to call it athletes_coaches, but I bet that might break Cake's automatic functionality.</p>
  
  <p>Will this work with the join table being called athletes_athletes?  Is this the right way to do it?  Is there a better way?</p>