是否为叶子节点 SELECT problem.*,( SELECT CASE WHEN count( 1 ) > 0 THEN 1 ELSE 0 END FROM problem_list WHERE parent_id = problem.id AND is_deleted = 0 ) AS has_children FROM problem_list problem WHERE is_deleted = 0 ```