SELECT *
,
(SELECT COUNT(campo_numero_click) FROM sub_cat WHERE id_cat = idprincipale) AS totaleclick
FROM sub_cat
LEFT JOIN cat ON (id_cat = idprincipale)
ORDER BY cat.categoria_principale_it ASC, sub_cat.nome_sub_it ASC