MySQL question: 2 queries in 1

[eluser]Pygon[/eluser]
I can't specifically answer for CI. The sql would be like:

SELECT * FROM tbl_user LEFT JOIN tbl_user_hobbies ON tbl_user.id = tbl_user_hobbies.user_id;

edit:

I think Alex covered it.