SELECT
    M_VOTE.BATTLE_ID, USER_REG.USER_ID, NICKNAME, UI.URL USER_THUMBNAIL , BI.URL USER_IMAGE, DESCRIPTION ,COUNT(M_VOTE.VALUE) VALUE
FROM M_BATTLE_USER
         LEFT JOIN USER_REG ON M_BATTLE_USER.USER_ID = USER_REG.USER_ID
         LEFT JOIN IMAGE UI ON USER_REG.IMAGE_ID = UI.ID
         LEFT JOIN IMAGE BI ON M_BATTLE_USER.IMAGE_ID = BI.ID
         LEFT JOIN M_VOTE ON M_BATTLE_USER.BATTLE_ID= M_VOTE.BATTLE_ID AND M_VOTE.USER_ID= USER_REG.USER_ID
WHERE M_BATTLE_USER.BATTLE_ID = :battleId
GROUP BY USER_REG.USER_ID