Compound Query

[eluser]bhbutter123[/eluser]
I have what I believe to be a tough situation and am looking for advice. I have a mysql table with a column named 'name' and another called 'category'. There will be multiple files with the same category. I want the display to do something similair to the following:

Category
Name
Name
Name
Another Category
Name
Name

Name in the first and second categories is not the same, it is just a placeholder.
I believe this to be possible using one model function and returning it as a multilevel array but am not sure how to do it.