计算字符串中逗号最多的有多少个

SELECT id, LENGTH(path) - LENGTH(REPLACE(path, ',', ''))  FROM tongfu_user where LENGTH(path) - LENGTH(REPLACE(path, ',', '')) = ( select max(LENGTH(path) - LENGTH(REPLACE(path, ',', ''))) from tongfu_user )