MYSQL joins tables several times

Question

I have a table with event strings, and each of them (among many other fields) addedbyuser , editedbyuser , deletedbyuser There is an INT , and refer to the users table for a specific user. I can join one of the fields (say addedbyuser ) without any problems, how can I join the others and refer to them in php?

event table:

 eventid addedbyuser editedbyuser deletedbyuser 1 1 2 3 

user table:

 id username 1 name1 2 name2 3 name3 

So basically, I want to display the names of those who added, edited and deleted the article, can I do this in a single SQL query?

Answer 1

Something like that:

 select evn.eventid, us1.username as addedbyuser, us2.username as editedbyuser, us3.username as deletedbyuser, from events evn join users as us1 on evn.addedbyuser = us1.id join users as us2 on evn.editedbyuser = us2.id join users as us3 on evn.deletedbyuser = us3.id