1.【JOIN】基本構文

2.【コードイグナイター】CIで書いてみよう

3.【VIEW】で取り出す

4.【まとめ】忘れやすい

UPDATE orders
JOIN customers

ON

orders_t.customer_id = customers_t.customer_id

SET

orders_t.customer_id = 3,

customers_t.name = makio

WHERE

orders_t.id = 1;

public function get_school_data(){

$query=$this->db->query("
SELECT
company_t.company_id,company_name_t.company_name.....（欲しいテーブル+カラム）

FROM
company_t

JOIN company_name_t
ON company_name_t.company_id=company_t.company_id

JOIN school_t
ON company_t.company_id=school_t.company_id

JOIN school_name_t
USING (school_id)

JOIN room_t
USING (room_id)

WHERE company_t.company_id

;");

return $query->result_array();

}

<?php $company_name=$this->zyuku_model->get_school_data(); ?>

<table class="table3">
<tbody>
<tr class="wh">
<td bgcolor="#40A697"><p>会社id</p></td>
<td bgcolor="#40A697"><p>会社名</p></td>
<td bgcolor="#40A697"><p>塾id</p></td>
<td bgcolor="#40A697"><p>塾名</p></td>
<td bgcolor="#40A697"><p>校舎・教室id</p></td>
<td bgcolor="#40A697"><p>校舎・教室名</p></td>
</tr><!--foreachはループさせたい場所に書く↓↓ -->
<?php foreach($company_name as $company_names): ?>
<tr>
<td><p><?php echo $company_names['company_id']; ?></p></td>
<td><p><?php echo $company_names['company_name']; ?></p></td>
<td><p><?php echo $company_names['school_id']; ?></p></td>
<td><p><?php echo $company_names['school_name']; ?></p></td>
<td><p><?php echo $company_names['room_id']; ?></p></td>
<td><p><?php echo $company_names['room_name']; ?></p></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>

<?php $company_name=$this->zyuku_model->get_school_data(); ?>

<?php endforeach; ?>

ループの指定場所が大事です。