Existing staff table, rank relations director, manager, director, ordinary staff, director, senior director of graded layer, not as big, ordinary staff is


Group ID (org_code) ID name (name) (group_code) personnel rank


Relationship between database tables is director of the department ID=manager department ID manager department ID=, director of the department ID, director of the group ID=average employee group ID of the

Can query results into a tree structure?

CodePudding user response:

There are 2 kinds of circumstances, director of the ordinary employees and no led
Ordinary employees -- - director no department manager, director of the