public function getLists() { $query = 'SELECT projects.name as project, tasks.name, tasks.status FROM projects INNER JOIN tasks ON projects.id=tasks.projects_id ORDER BY projects.id;'; parent::connectDataBase($query); $lists = parent::getMySqlResult(); var_dump($lists); $newLists = array(); foreach ($lists as $index => $array) { if (!array_search($array['project'], $newLists[$index])) { $newLists[$index]['project'] = $array['project']; $newLists[$index]['tasks'] = array('name' => $array['name'], 'status' => $array['status']); } } parent::responseJSON($newLists); var_dump($newLists); }