如何将user表与log表进行两次关联查询以获取指定结果

要通过两次关联user表和log表，从log表的user_id和guest_id字段分别获取对应的用户名，最终得到user_name和guest_name的结果。

已知表结构及数据 #

user表 #

id = 1, name = David
id = 2, name = Jhon

log表 #

user_id = 1, guest_id = 2

关联查询SQL语句 #

SELECT 
    u1.name AS user_name,
    u2.name AS guest_name
FROM log
JOIN user u1 ON log.user_id = u1.id
JOIN user u2 ON log.guest_id = u2.id;

查询结果 #

user_name = David
guest_name = Jhon

内容的提问来源于stack exchange，提问作者manjil Sthapit