sql adjacency list children for node

sql adjacency list children for node

given context: How to copy a node's children in an adjacent list
In an adjacency list, how do you pick any node and get all children?
For example, see highlighted nodes below.