multiple query and foreach loop

[eluser]forzaferrari87[/eluser]
Hallo,
I am a newbie at CodeIgniter and want to know how does something.

I have two tables. One of the is a category table and the other a normal one for informations. In my case I want to print out first the category with a foreach loop. That works. But in my second query I want to print out the information with the correct category. Without a framework I did this by a second foreach loop.

My question. How I can print out the second table throught the id of the category table?

Also I am searching at Google too, but I don't found the correct solution till now.