In spring jpa

1. Create Role entity
2. Create Permission entity
3. Create one to many relation.
4. Create repositoryRole and repositoryPermission.
5. In reposityRole Create method with you query or List findByRoleNameIn(List roleNames)
6. Call this method - var roles = role Repository.findByRoleNameIn(List.of("user_admin","db_admin"));
7. And you can transformate List to map Map<String, Choice> result = roles.stream().collect(Collectors.toMap(Roles::getName,Roles::gerPermission )