查询优化(查多次改为只查一次)

private List<IotUserVO> converToIotUserVO(List<IotUser> iotUserList,BizInfo bizInfo){
    if(CollectionUtils.isEmpty(iotUserList)){
        return Collections.emptyList();
    }
    //批量获取siteInfo,只查一次
    Map<String, SiteInfo> siteInfoMap;
    List<String> siteIdList = iotUserList.stream().map(IotUser::getUserSiteId).distinct().collect(Collectors.toList());
    if(CollectionUtils.isNotEmpty(siteIdList)){
        List<SiteInfo> siteInfoList = coaSiteInfoService.selectSiteInfoBySiteIdList(siteIdList);
        siteInfoMap = siteInfoList.stream().collect(Collectors.toMap(SiteInfo::getSiteId, item -> item));
    }else{
        siteInfoMap = Collections.emptyMap();
    }
    return iotUserList.stream().map(user -> {
        IotUserVO vo = new IotUserVO();
        BeanUtils.copyProperties(user,vo);
        vo.setUserBizName(bizInfo.getBizName());
        vo.setUserBizLevel(bizInfo.getBizLevel());
        vo.setUserSiteName(StringUtils.isNotEmpty(user.getUserSiteId())?siteInfoMap.get(user.getUserSiteId()).getSiteName():StringUtils.EMPTY);
        EmpUser empUser = this.getInvitationCodeName(user.getIotUserDetail().getInvitationCode());
        vo.setInvitationCodeName(empUser!=null?empUser.getEmpName():StringUtils.EMPTY);
        vo.setInvitationEmpNo(empUser!=null?empUser.getEmpNo():StringUtils.EMPTY);
        return vo;
    }).collect(Collectors.toList());
}