经典sql

SELECT
a.*,(select now())signUp,
CASE
WHEN b1.id IS NULL THEN
'未报名' ELSE '已报名'
END sate,
( SELECT COUNT( 1 ) FROM group_look_applicants c WHERE c.group_look_id = a.id ) sum1
FROM
group_look a
LEFT JOIN group_look_applicants b1 ON a.id = b1.group_look_id AND b1.telephone = "18857499211"