sql映射vo注意事项

 select s.user_id as userId, s.user_name as userName,s.user_photo as userPhoto, count(1) as score from voluntary_activity_signup s where s.is_apply= 0 and s.delete_flag = 0 group by s.user_id order by score desc

@Data
public class InfoT {
    private String userName;
    private String userId;
    private String userPhoto;
    private BigInteger score;
}

 Query q = em.createNativeQuery(sql);
        q.unwrap(SQLQuery.class).setResultTransformer(Transformers.aliasToBean(clazz));
        List resultList = q.getResultList();
        return resultList;