ActiveRecord for CodeIgniter: Rails-style model interactions

[eluser]beemr[/eluser]
Sounds like you are looking for a has_many :through relationship. There's been a lot of excitement about that relationship over in the Rails community, but it also seems to have been a difficult improvement for them to make. Some RoR devs are open about their distaste for it, and it has spawned a set of bugs that seem excessive when compared to HABTM which was whole and intact from the start.

That being said, it has definitely kept my interest as the potential "killer" function of Rails. I'd love to see a form of it implemented for our beloved CodeIgniter. For your particular use case, it sounds as if you'd use has_many :through to create self-referential relationships. I found a link for something similar in RoR.

self-referential has_many :through