Table bjlife_template and bjlife_template_type related inquiries, pay attention to the table alias subTree.select subTree played. *, (Select template_type_name from bjlife_template_type where template_type_dm = subTree.template_type_dm) as name from bjlife_template subTree