MybatisPlus中使用多表数据,合并数据后再分页

  List<Project> projectList = sysProjectMapper.selectList(queryWrapperProject);
        List<ProjectReported> projectReportedList = sysProjectReportedMapper.selectList(queryWrapper);
        List<ProjectReported> finalProject = new ArrayList<ProjectReported>();
        //强转公司项目成为报备项目
        for (Project project : projectList
        ) {
            finalProject.add(project);
        }
        for (ProjectReported projectReported1 : projectReportedList
        ) {
            finalProject.add(projectReported1);
        }
        IPage<ProjectReported> iPage = page(new Page<>());
        iPage.setRecords(finalProject);
        iPage.setTotal(finalProject.size());
        int startIndex=limit*(page-1);
        int endIndex= Math.min(limit * page, finalProject.size());
        return new LayTableResult<>(iPage.getTotal(), iPage.getRecords().subList(startIndex,endIndex));