In https://www.sqlite.org/lang_with.html

One or more of the individual SELECT statements that make up the compound must be "recursive". A SELECT statement is a recursive if its FROM clause contains exactly one reference to the the CTE table (the table named on the left-hand side of the AS clause).