mysql selecting latest records

[rjames]

Hello,

I have a mysql database with users that fall under one of 4 categories. I need to run a query to :

select 4 latest users, 1 from each category.

How can i format my select statement to acomplish this?

the fields to use are:
username, category, signupdate

I'd appreciate any help. Thanks