如何在codeigniter中显示多个mysql表中的频率计数

class Frequency_model extends CI_Model {
    public function get_frequency_counts() {
        $this->db->select('table1.column, COUNT(*) as count');
        $this->db->from('table1');
        $this->db->join('table2', 'table1.id = table2.table1_id');
        $this->db->group_by('table1.column');
        $query = $this->db->get();
        return $query->result();
    }
}

class Frequency extends CI_Controller {
    public function index() {
        $this->load->model('frequency_model');
        $data['frequency_counts'] = $this->frequency_model->get_frequency_counts();
        $this->load->view('frequency_view', $data);
    }
}

<?php foreach ($frequency_counts as $count): ?>
    <p><?php echo $count->column; ?>: <?php echo $count->count; ?></p>
<?php endforeach; ?>