Select inner join (форматирование вывода)

/**
     * @param int    $offset
     * @param int    $count
     * @param string $lang
     *
     * @return void
     * @throws ExceptionSafeMySQL
     */
    public function getAll(int $offset = 0, $count = 10, $lang = 'ru')
    {
        // $language_id = $this->language->getId($lang);
        $obj = new stdClass();
        $obj->product = [];
        $obj->product = $this->db()->getAll("select * from product limit ?i, ?i", $offset, $count);
 
        foreach ($obj->product as $key => $item){
            // TODO: "афтор" дурак
        }
    }

/**
     * @param int    $offset
     * @param int    $count
     * @param string $lang
     *
     * @return array
     * @throws ExceptionSafeMySQL
     */
    public function getAll(int $offset = 0, int $count = 10, $lang = 'ru')
    {
        $language_id = $this->language->getId($lang);
        $data = $this->db()->getAll("select p.*, pd.title from product p inner join product_description pd on p.id = pd.product_id and pd.language_id = ?i  limit ?i, ?i", $language_id, $offset, $count);
        foreach ($data as $key => $item){
            $data[$key]['images'] = (array)$this->getProductImages($item['id']);
        }
        return $data;
    }
 
 
    /**
     * @param int $product_id
     *
     * @return array
     * @throws ExceptionSafeMySQL
     */
    public function getProductImages(int $product_id)
    {
        return $this->db()->getCol("select image from product_image where product_id = ?i", $product_id);
    }