$query = "select * from oa_request_def as a inner join (select code,name from app_dict_def where dict_id = 'oa_request_flow_type') as b on a.check_user_method = b.code";