SQL to get the list all user ids that are assigned to a specific permission-list

SELECT DISTINCT C.ROLEUSER AS USER_IDS
      FROM PSCLASSDEFN A, PSROLECLASS B, PSROLEUSER C
     WHERE A.CLASSID = B.CLASSID
       AND B.ROLENAME = C.ROLENAME
       AND A.CLASSID = 'Permission List Name';