For some reason you might prefer this:
[sql]
select
projects.name,
developer.name as "developer",
requestor.name as "requestor"
from
projects
join people developer on (developer.id = projects.developer)
join people requestor on (requestor.id = projects.requestor)
[/sql]
Consider however the type of join you need (perhaps "left" one?).