Активная запись CodeIgniter для присоединения к таблицам ⇐ Php

[Anonymous]

Я следующий таблицам. < /p>
apartments
id name slug created modified

apartment_amenities
id name slug apartment_id created modified

apartment_activities
id name slug apartment_id created modified
< /code>
В представлении я хотел что -то подобное. < /p>
no apartment_name amenities activities

1 shobha_comnplex party hall pamplets
swimming pool banners
play area boards

2 navami_comnplex party hall boards
swimming pool banners
club house pamplets
< /code>
В модели я попробовал так. < /p>
$this->db->select('apartments.id, apartments.slug, apartments.name, apartment_amenities.name as amenity_name, apartment_activities.name as activity_name');
$this->db->from($this->_table);
$this->db->group_by($this->_table.'.id');
$this->db->join('apartment_amenities', 'apartment_amenities.apartment_id = apartments.id', 'left');
$this->db->join('apartment_activities', 'apartment_activities.apartment_id = apartments.id', 'left');
return $this->db->get();
< /code>
Но я получаю только единую удобство и активность, даже в квартире много удобств и действий. Результат следующим образом. < /P>
Array
(
[0] =>
(
[id] => 1
[slug] => shobha_complex
[name] => shobha complex
[amenity_name] => party hall
[activity_name] => pamplets
),

[1] =>
(
[id] => 1
[slug] => navami_complex
[name] => navami complex
[amenity_name] => party hall
[activity_name] => boards
)
)
< /code>
Я хочу результат, что -то вроде следующего. < /p>
Array
(
[0] =>
(
[id] => 1
[slug] => shobha_complex
[name] => shobha complex
[amenities] => Array(
[0] =>
(
[name] => party hall
),
[1] =>
(
[name] => swimming pool
),
[2] =>
(
[name] => play area
)
),
[activities] => Array(
[0] =>
(
[name] => pamplets
),
[1] =>
(
[name] => banners
),
[2] =>
(
[name] => boards
)
)
),

[1] =>
(
[id] => 1
[slug] => navami_complex
[name] => Navami complex
[amenities] => Array(
[0] =>
(
[name] => party hall
),
[1] =>
(
[name] => swimming pool
),
[2] =>
(
[name] => club house
)
),
[activities] => Array(
[0] =>
(
[name] => boards
),
[1] =>
(
[name] => banners
),
[2] =>
(
[name] => pamplets
)
)
),
)
< /code>
Пожалуйста, предложите мне, как я получу решение. Работа была бы более оценена.

Подробнее здесь: https://stackoverflow.com/questions/215 ... the-tables