左连接查询

    select
      <include refid="permission_column" />
    from sys_permission as p
    left join sys_role_permission as rp
    on p.id = rp.sys_permission_id
    left join sys_user_role as ur
    on rp.sys_role_id = ur.sys_role_id
    where sys_user_id = #{0}