MyBatis多对多关系关联id含逗号查法

多对多关系我没用第三表做关联，这里是把关联的id设为varchar类型用，分割。所以关联时子表的devopsid中是否含有父表的主键id所以用FIND_IN_SET(父表的id,子表的devopsid)：精确查询devopsid中含有父表的id。

sql语句：SELECT * FROM oper_devops o LEFT JOIN oper_devops_maintain o1 on FIND_IN_SET(o.id,o1.devopsid)

但我们想返回一个 父类中含多个子的数据形式：

需要定义一个Vo类：

import java.util.Date;
import java.util.List;
import com.fasterxml.jackson.annotation.JsonFormat;


**专业代缴补交社保公积金，限南京合肥。**



public class MainAndDevOpsVo{
   

	private Long mainid;
	
	private String site;
    
	private String siteid;
	
	private String personnel;
    
    private String personnelid;
	
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private Date endexpecttime;

	private String devopsid;
    
    private Long delstatus;
	
	private List<DevOps> devOps;

	public Long getMainid() {
   
		return mainid;
	}

	public void setMainid(Long mainid) {
   
		this.mainid = mainid;
	}

	public String getSite() {
   
		return site;
	}

	public void setSite(String site) {
   
		this.site = site;
	}

	public String getSiteid() {
   
		return siteid;
	}

	public void setSiteid(String siteid) {
   
		this.siteid = siteid;
	}

	public String getPersonnel() {
   
		return personnel;
	}

	public void setPersonnel(String personnel) {
   
		this.personnel = personnel;
	}

	public Date getEndexpecttime() {
   
		return endexpecttime;
	}

	public void setEndexpecttime(Date endexpecttime)