$manufacturers = Manufacturer::getManufacturers();

if (!$id_category = Tools::getValue('id_category'))
            return;

        $manufacturers = Db::getInstance()->ExecuteS('
        SELECT *
        FROM `'._DB_PREFIX_.'manufacturer` m
        '.Shop::addSqlAssociation('manufacturer', 'm').'
        INNER JOIN `'._DB_PREFIX_.'manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = '.(int)$this->context->cookie->id_lang.')
        WHERE m.`active` = 1
        AND m.id_manufacturer IN (SELECT p.`id_manufacturer`
        FROM `'._DB_PREFIX_.'category_product` cp
            LEFT JOIN `'._DB_PREFIX_.'product` p ON (p.`id_product` = cp.`id_product`)
            WHERE cp.`id_category` = '.(int)$id_category.' AND p.`active` = 1
        )');