copy

 SELECT sp.permid, sp.permtype, s.spacekey, s.spacename, sp.permgroupname, um.user_name

FROM SPACEPERMISSIONS sp

JOIN SPACES s ON sp.spaceid = s.spaceid

LEFT JOIN cwd_user um ON sp.permusername = um.user_name