WITH RECURSIVE component AS (
   SELECT
      name1
   FROM
      metric2
   WHERE
      name1 = 'Makoto Takizawa 0001'
   UNION
      SELECT
         p2.name1
      FROM
         metric2 p2
      INNER JOIN component p1 ON p2.name2 = p1.name1
) SELECT
   COUNT(*)
FROM
   component;