OpenCart 🇺🇦

$filter_data = array();

$filter_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "filter WHERE filter_group_id = '" . (int)$filter_group_id . "'");

foreach ($filter_query->rows as $filter) {
	$filter_description_data = array();

	$filter_description_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "filter_description WHERE filter_id = '" . (int)$filter['filter_id'] . "'");			

	foreach ($filter_description_query->rows as $filter_description) {
		$filter_description_data[$filter_description['language_id']] = array('name' => $filter_description['name']);
	}

	$filter_data[] = array(
		'filter_id'          => $filter['filter_id'],
		'filter_description' => $filter_description_data,
		'sort_order'         => $filter['sort_order']
	);
}

return $filter_data;