你的问题类似于用count连接3个表。试试这个sql。这也许能解决你的问题。

SELECT 
        p.label,
        Count( t.id_latihan ) AS id_latihan 
    FROM 
        euclidean p 
        LEFT JOIN euclidean t ON p.id_latihan = t.id_latihan
    where 
        p.id_latihan = 46
    GROUP BY 
        p.label

选择标签，从中计数（*） euclidean 其中id_latihan='46'按标签分组顺序按标签限制3

假设您希望从select中得到结果计数，您可以使用

select label, count(*)
from (
    SELECT * 
    FROM  `euclidean` 
    WHERE id_latihan =  '46'
    ORDER BY jarak ASC 
    LIMIT 3) t 
group by label

或直接形成您的查询

SELECT label, count(*)
    FROM  `euclidean` 
    WHERE id_latihan =  '46'
    GROUP BY label
    ORDER BY label