前言

当查询的内容包含多张表的内容，Mybatis-Plus是无法实现的，这里提供一种Mybatis+Mybatis-Plus方式。
企业（Enterprise）与运营状态为一对一关系，企业与企业分类（Category）是多对多关系

实体类

企业类的VO:

@Data
public class EnterpriseVo {
    @Excel(name = "企业分类")
    private List<Category> category;
	
    @Excel(name = "运营状态")
    private String operateStatus;

    @Excel(name = "序号", cellType = Excel.ColumnType.NUMERIC)
    private Integer id;

    @Excel(name = "企业名称")
    private String name;

    @Excel(name = "所属区域")
    private Integer regionId;

    @Excel(name = "详细地址")
    private String address;

    @Excel(name = "注册资本")
    private Integer registerCapital;

    @Excel(name = "成立日期")
    private LocalDate establishDate;

    @Excel(name = "经营范围")
    private String businessScope;

    @Excel(name = "联系方式")
    private String phone;

    @Excel(name = "企业LOGO")
    private String logoUrl;

    @Excel(name = "企业用户ID")
    private Integer enterpriseUserId;

    @Excel(name = "视频推送状态#0:正常#1:优推#2:下架")
    private Integer pushStatus;

    @Excel(name = "优势产品")
    private String featureProduct;

    @Excel(name = "优势分析")
    private String advantageAnalysis;

    @Excel(name = "隐私设置#0:显示#1:隐藏")
    private Integer privacySetting;

    @Excel(name = "运营状态ID")
    private Integer operateStatusId;

    @Excel(name = "统一信用社会代码")
    private String socialCode;

    @Excel(name = "营业执照")
    private String licenseUrl;

    @Excel(name = "法人身份证")
    private String legalPersonCardUrl;

    @Excel(name = "企业认证公函")
    private String letterUrl;

    @Excel(name = "管理人")
    private String manager;

    @Excel(name = "法人")
    private String legalPerson;

    @Excel(name = "法人联系方式")
    private String legalPersonPhone;

    @Excel(name = "审核状态#0:未审核#1:通过#2:驳回")
    private Integer auditStatus;

    @Excel(name = "驳回原因")
    private String rejectionReason;

    @Excel(name = "审核时间",width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime auditTime;

    @ApiModelProperty(value = "更新时间")
    @Excel(name = "更新时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updateTime;

    @ApiModelProperty(value = "创建时间")
    @Excel(name = "创建时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    @JsonFormat(shape = JsonFormat.Shape.STRING, pattern="yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTimeBegin;

    @JsonFormat(shape = JsonFormat.Shape.STRING, pattern="yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTimeEnd;

    @Excel(name = "删除标识")
    private Boolean deleteFlag;

    @Excel(name = "视频")
    private String videoUrl;

企业分类：

@Data
public class Category {
    private Integer id;
    private String name;
}

EnterpriseMapper文件

EnterpriseMapper.xml文件

CategoryMapper文件

CategoryMapper.xml文件

EnterpriseService文件

EnterpriseServiceImpl文件

EnterpriseController

后台查询结果：