# `getSysjurisdictionChildrenPro` (procedure)

> 获取权限树的子权限（递归用）


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sLague` | `varchar(8)` |
| 2 | IN | `sbid` | `varchar(255)` |
| 3 | IN | `ssid` | `varchar(255)` |
| 4 | IN | `p_pSid` | `varchar(255)` |
| 5 | IN | `p_key` | `varchar(255)` |
| 6 | IN | `sLicense` | `text` |
| 7 | IN | `treeNode` | `longtext` |
| 8 | OUT | `newTreeNode` | `longtext` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `getSysjurisdictionChildrenPro`'`._

## Narrative

_No human-written narrative yet._