如何正确理解CTE中的递归

WITH RECURSIVE cteSource (counter) AS (
    (SELECT 1)
    UNION ALL
    (SELECT counter + 1 FROM cteSource
    WHERE counter < 10)
)
SELECT * FROM cteSource

这段代码的执行过程是怎样的？

https://blog.csdn.net/3150379/article/details/54865603