SELECT * FROM ecru_product_filter_category WHERE filter_id IN(SELECT product_filter_id FROM ecru_product_filter WHERE filter_link='style' AND filter_status=1) AND filter_category_status=1 ORDER BY filter_category_order ASC
Array
(
    [0] => Array
        (
            [product_filter_category_id] => 10
            [filter_id] => 2
            [filter_category_name] => Texturize<br>and Groom
            [filter_category_link] => texturize-and-groom
            [filter_category_new] => 0
            [filter_category_order] => 1
            [products] => 51,52
            [freq_used_products] => 54,8
            [filter_category_status] => 1
        )

    [1] => Array
        (
            [product_filter_category_id] => 11
            [filter_id] => 2
            [filter_category_name] => Subtle Body<br>and Sheen
            [filter_category_link] => subtle-body-and-sheen
            [filter_category_new] => 0
            [filter_category_order] => 2
            [products] => 16,8
            [freq_used_products] => 53,10
            [filter_category_status] => 1
        )

    [2] => Array
        (
            [product_filter_category_id] => 12
            [filter_id] => 2
            [filter_category_name] => Curls Without Frizz
            [filter_category_link] => curls-without-frizz
            [filter_category_new] => 0
            [filter_category_order] => 3
            [products] => 45,44
            [freq_used_products] => 16,53
            [filter_category_status] => 1
        )

    [3] => Array
        (
            [product_filter_category_id] => 13
            [filter_id] => 2
            [filter_category_name] => Smooth<br>and Silky
            [filter_category_link] => smooth-and-silky
            [filter_category_new] => 0
            [filter_category_order] => 4
            [products] => 3,16
            [freq_used_products] => 10
            [filter_category_status] => 1
        )

    [4] => Array
        (
            [product_filter_category_id] => 14
            [filter_id] => 2
            [filter_category_name] => Maximum Volume
            [filter_category_link] => maximum-volume
            [filter_category_new] => 0
            [filter_category_order] => 5
            [products] => 7,54
            [freq_used_products] => 11,52
            [filter_category_status] => 1
        )

    [5] => Array
        (
            [product_filter_category_id] => 15
            [filter_id] => 2
            [filter_category_name] => Creating Curls<br>that Last<br>(Hot Tool Use)
            [filter_category_link] => creating-curls-that-last-hot-tool-use
            [filter_category_new] => 0
            [filter_category_order] => 6
            [products] => 11
            [freq_used_products] => 54,53
            [filter_category_status] => 1
        )

)