SELECT DISTINCT category.id, category.parent_id, category.name
FROM category_closure
    JOIN category ON category.id = category_closure.descendant
WHERE category_closure.ancestor > 1;