使用左连接一句话实现四张表的关联查询

需求：在自己的项目中遇到需求，现简化成如下有四张表，通过角色名查找日志记录
使用左连接进行查询
select logid , log.username from role left join user_role on role.roleid=user_role.roleid left join user on user_role.userid = user.userid left join log on user.username = log.username where role.rolename=‘用户’
结果：

select logid , log.username from role left join user_role on role.roleid=user_role.roleid left join user on user_role.userid = user.userid left join log on user.username = log.username where role.rolename=‘管理’
结果：