Get all child forums IDs

[amirreza13]

Hi dears

I need to get all child forums and their children from a category id
I used this query but this shows only child forums. I want to get all of children

SELECT name, fid from mybb_forums
WHERE pid=$pid

[frostschutz]

This user has been denied support.

You could check the parentlist instead of pid.

If you're doing this from within MyBB (like in a plugin), maybe it would be better to use the forums cache than querying it yourself. See admin/index.php?module=tools-cache&action=view&title=forums