Multiple db join on same table

[eluser]Wonder Woman[/eluser]
Thanks for your reply but they're not in separate tables, I have author and modified_by in the news table, which stores the id of a user which I want to retrieve from the users table.

For example, an article might have been created by author whose id is 1 but later edited by a user whose id is 2...how do I amend my query to the db to get these two different users?