SELECT x.raid_id, x.member_id, y.description 
FROM 
    icono.raid_attendance x
LEFT JOIN
    icono.raid_loot y
ON
    y.member_id = x.member_id
WHERE 
    x.member_id = 6132 and x.active = 1