OpenCart 🇺🇦

$option_value_data = array();

$option_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "option_value WHERE option_id = '" . (int)$option_id . "'");

foreach ($option_value_query->rows as $option_value) {
	$option_value_description_data = array();

	$option_value_description_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "option_value_description WHERE option_value_id = '" . (int)$option_value['option_value_id'] . "'");			

	foreach ($option_value_description_query->rows as $option_value_description) {
		$option_value_description_data[$option_value_description['language_id']] = array('name' => $option_value_description['name']);
	}

	$option_value_data[] = array(
		'option_value_id'          => $option_value['option_value_id'],
		'option_value_description' => $option_value_description_data,
		'image'                    => $option_value['image'],
		'sort_order'               => $option_value['sort_order']
	);
}

return $option_value_data;