How to convert from Mysql query to Codeigniter syntax?

[eluser]sovandy[/eluser]
Thank you for your replying to me. I'm glad to get your help.
I don know how to convert from Mysql query to Codeigniter syntax. Here is my query:

SELECT lib_books.boo_id,
COUNT(lib_books.boo_id)AS number ,
lib_books.boo_title
FROM lib_borrowings bo
INNER JOIN lib_books
ON lib_books.boo_id=bo.boo_id
GROUP BY lib_books.boo_id;

I get the result that I want, but it difficult to implement in Codeigniter
And how to return from Model to Controller?
I think it return Array.


Please reply me soon if possible!
Thank you,