[Konstantinos]

PHP код:

SELECT h.*,a.username FROM houses h LEFT JOIN accounts a ON a.id=h.ownerid GROUP BY h.id; 


In case you use cache_get_row/cache_get_row_* functions, the player's name will be last.

EDIT: Didn't see the above, sorry.