Related tables by skills_id, you need to output an associative array in php, I do this:
db = Db::getconnection(); $skillslist = []; $result = $db->query('SELECT * FROM skills LEFT OUTER JOIN about ON skills.skills_id = about.skills_id'); $result -> execute(); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $skillslist[$row['skill_name']][] =$row; } //$row = $result->FETCHALL(PDO::FETCH_COLUMN|PDO::FETCH_GROUP); return $skillslist; 