||/Connect to database
||=A1.query("select * from Organization")
||/Query organization table
||/The foreign key Parent_ID is mapped to the record where the ID is located to realize self join
||=A2.select@1(ORG_NAME=="Beijing Branch Office")
||/Select the record of Beijing Branch
||/Create a new table consisting of ID, department name, and parent. The parent is obtained by recursively searching the records under Beijing branch through prior function.
||/Select the members whose parent exists, otherwise they are not subordinates of Beijing Branch.
||/concatenate all the parent names in the parent field, separated by commas.