Think you have to use a three table join, pages with uses with uses
SELECT [fill in pages cols] , usersOne.realname, usersTwo.realname
FROM pages, usersOne uses , usersTwo uses
WHERE create_id = usersOne.id AND modified_id = usersTwo.id
Note: you said the second table was "uses" and...