<dependency>
    <groupId>com.github.yulichang</groupId>
    <artifactId>mybatis-plus-join-boot-starter</artifactId>
    <version>1.4.5</version>
</dependency>

import icu.mhb.mybatisplus.plugln.base.mapper.JoinBaseMapper;

public interface UserMapper extends JoinBaseMapper<User> {
   
}

import icu.mhb.mybatisplus.plugln.base.service.JoinIService;

public interface UserService extends JoinIService<User> {
   
}

import icu.mhb.mybatisplus.plugln.base.service.impl.JoinServiceImpl;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl extends JoinServiceImpl<UserMapper, User> implements UserService {
   
}

// 方式一：通過 Service 直接獲取
JoinLambdaWrapper<User> wrapper = userService.joinLambdaWrapper();

// 方式二：手動(dòng)創(chuàng)建
JoinLambdaWrapper<User> wrapper = new JoinLambdaWrapper<>(User.class);

// 左連接
wrapper.leftJoin(Department.class, Department::getId, User::getDeptId);

// 右連接
wrapper.rightJoin(Department.class, Department::getId, User::getDeptId);

// 內(nèi)連接
wrapper.innerJoin(Department.class, Department::getId, User::getDeptId);

wrapper.eq(Department::getName, "技術(shù)部")
       .like(User::getName, "張")
       .gt(User::getAge, 25);

// 結(jié)束當(dāng)前連接（重要?。?
wrapper.end();

// 執(zhí)行查詢
List<UserVO> result = userService.joinList(wrapper, UserVO.class);

public List<UserVO> findUsersWithMultiJoin() {
    JoinLambdaWrapper<User> wrapper = userService.joinLambdaWrapper();
    
    // 第一重連接：部門表
    wrapper.leftJoin(Department.class, Department::getId, User::getDeptId)
           .selectAs(Department::getName, UserVO::getDeptName)
           .end();
    
    // 第二重連接：職位表
    wrapper.leftJoin(Position.class, Position::getUserId, User::getId)
           .eq(Position::getLevel, "P7")
           .selectAs(Position::getName, UserVO::getPositionName)
           .end();
    
    return userService.joinList(wrapper, UserVO.class);
}