通过一段API了解MybatisPlus的联合查询

须知：Record实体类存取的是2个玩家（User实体类）的id

@Autowired
    private UserMapper userMapper;

    @Autowired
    private RecordMapper recordMapper;

    @Override
    public JSONObject GetRecord(int page) {
        JSONObject resp = new JSONObject();
        IPage<Record> recordPage = new Page<>();
        QueryWrapper<Record> queryWrapper = new QueryWrapper<>();
        queryWrapper.orderByDesc("id");
        List<Record> records = recordMapper.selectPage(recordPage, queryWrapper).getRecords();
        List<JSONObject> resps = new ArrayList<>();
        for (Record r : records) {
            User userA = userMapper.selectById(r.getAId());
            User userB = userMapper.selectById(r.getBId());
            JSONObject item = new JSONObject();
            item.put("a_photo",userA.getPhoto());
            item.put("a_username",us