message table schema

id
to_id
from_id
message
status
location
created

this is what i have so far...
SELECT MAX(messages.created), messages.*, members.username FROM messages LEFT JOIN members ON messages.from_id=members.id WHERE to_id = '1' AND location = 'inbox' GROUP BY members.username