jeecgboot跨表联合查询分页查询

@GetMapping(value = "/list")
public Result<IPage<EmpInfo>> queryPageList(EmpInfo empInfo,
                                            @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                            @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
                                            HttpServletRequest req) {
  QueryWrapper<EmpInfo> queryWrapper = QueryGenerator.initQueryWrapper(empInfo, req.getParameterMap());
  // queryWrapper.like("emp_name", empInfo.getEmpName());
    Page<EmpInfo> page = new Page<EmpInfo>(pageNo, pageSize);
    IPage<EmpInfo> pageList = tellerService.getPage(page, queryWrapper);
    return Result.OK(pageList);
}

@GetMapping(value = "/list")
public Result<IPage<EmpInfo>> queryPageList(EmpInfo empInfo,
                                            @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                            @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
                                            HttpServletRequest req) {
    Page<EmpInfo> page = new Page<EmpInfo>(pageNo, pageSize);
    IPage<EmpInfo> pageList = tellerService.getPage(page, empInfo);
    return Result.OK(pageList);
}

@Service
public class TellerServiceImpl extends ServiceImpl<TellerMapper, EmpInfo> implements ITellerService {
  public IPage<EmpInfo> getPage(Page<EmpInfo> page, EmpInfo empInfo) {
      return tellerMapper.getPage(page, empInfo);
  }
}

public interface TellerMapper extends BaseMapper<EmpInfo> {
  @Select("<script>"
          + "select a.id, a.emp_name, a.emp_no,b.post_name,b.post_name as post_mutex,b.sys_org_code" +
          "        from ls_emp_info a left join ls_emp_post b on a.emp_no = b.emp_no " +
          "        <where>" +
          "            <if test=\"empInfo.empName != null and empInfo.empName != ''\"> " +
          "               and a.emp_name like CONCAT('%',#{empInfo.empName},'%')" +
          "            </if>" +
          "        </where>"
          + "</script>")
  IPage<EmpInfo> getPage(Page<EmpInfo> page, @Param("empInfo") EmpInfo empInfo);
}