Request Feature: Payee & Category as dropdown about web-money-manager-ex HOT 1 OPEN

WITH RECURSIVE categories(categid, categname, parentid) AS 
(SELECT a.categid, a.categname, a.parentid FROM category_v1 a WHERE parentid = '-1' 
UNION ALL 
SELECT c.categid, r.categname || ':' || c.categname, c.parentid 
FROM categories r, category_v1 c 
WHERE r.categid = c.parentid) 
 SELECT categid, categname FROM categories ORDER by categname;