package zy.cloud.wms.system.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; import zy.cloud.wms.system.entity.User; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; import java.util.List; @Mapper @Repository public interface UserMapper extends BaseMapper { @Select("select sys_user.* from sys_user left join sys_dept on sys_user.dept_id = sys_dept.id where sys_dept.parent_id = 1") List getUserByDept(Long deptId); }