select catalogs.*, 
(SELECT COUNT(*) FROM oproduct_to_catalog WHERE product_to_catalog.catalog_id = catalogs.id) AS product_cnt 
from catalogs

CREATE TABLE `catalogs` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`)
)

CREATE TABLE `product_to_catalog` (
    `catalog_id` INT(11) NOT NULL,
    `product_id` INT(11) NOT NULL
)

CREATE TABLE `products` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `sku` VARCHAR(20) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `price` DOUBLE(8,2) NOT NULL,
    `image_url` VARCHAR(160) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `mbr_status` TINYINT(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
)