CodeIgniter博客:在评论表中显示文章标题

我正在做一个 博客应用程序 在codeigner 3.1.8和bootstrap 4中。

有一个 帖子 表和A 评论 数据库中的表。我已经在bootstrap 4表中显示了所有注释。我想展示 标题 每个评论所属的,而不是帖子的 身份证件 :

我的评论控制器:

class Comments extends CI_Controller {

  public function __construct()
  {
    parent::__construct();
    $this->load->model('Static_model');
    $this->load->model('Posts_model');
    $this->load->model('Categories_model');
    $this->load->model('Comments_model');
  }

  public function index() {
    $data = $this->Static_model->get_static_data();
    $data['categories'] = $this->Categories_model->get_categories();
    $data['number_of_categories'] = $this->Categories_model->get_num_rows();
    $data['posts'] = $this->Posts_model->get_all_posts();
    $data['number_of_posts'] = $this->Posts_model->get_num_rows();
    $data['comments'] = $this->Comments_model->get_all_comments();

    $this->load->view('partials/header', $data);
    $this->load->view('dashboard/comments');
    $this->load->view('partials/footer');
  }
}

在 注释\模型 我拥有的型号:

public function get_all_comments(){
    $this->db->select('comments.*');
    $this->db->order_by('comments.id', 'DESC');
    //$this->db->limit($limit, $offset);
    $this->db->join('posts', 'posts.id = comments.post_id');        
    $query = $this->db->get('comments');
    return $query->result();
}

在视图中:

<tbody>
  <?php foreach ($comments as $index => $comment): ?>
  <tr id="<?php echo $comment->id; ?>">
    <td><?php echo $index + 1; ?></td>
    <td class="w-25"><?php echo $comment->comment; ?></td>
    <td><?php echo $comment->name; ?></td>
    <td><?php echo $posts['title']; ?></td>
    <td><?php echo nice_date($comment->created_at, 'D, M d, Y'); ?></td>
    <td>Aproved</td>
    <td></td>
  </tr>
  <?php endforeach ?>
</tbody>

同时 <?php echo $posts->id; ?> 显示我在视图中不需要的文章ID,行 结果是