weixin_41979303的博客

1，给出公司，查出公司的所有父级。 SELECT ou, cn, company_id, company_name, parent_id, new_order, create_time, is_company FROM ( select @id as _id, (select @id := parent_id from sys_new_org where ou in (_id)) as ids from sys_new_org t where