SELECT b1.jd_category_name ,b2.jd_category_name ,b3.jd_category_name FROM xdsh_jd_category AS b1 JOIN xdsh_jd_category AS b2 JOIN xdsh_jd_category AS b3 ON b1.id=b2.super_category_id AND b2.id=b3.super_category_id and b1.id =1
写一个实体类包含这几个字段 如果是mybatis 映射到相对应的字段上即可 如果是其他插件 参考官方文档