sql 根据生日查询年龄中间表查爱好

SELECT
	u.*, TIMESTAMPDIFF(YEAR, u.birthday, now()) age,
	TIMESTAMPDIFF(WEEK, u.last_a_time, now()) preWeek
FROM
	t_gravida u

===========================

  SELECT
    	u.*, GROUP_CONCAT(f.name) fname
    FROM
    	tb_user u
    LEFT JOIN tb_middle ph ON u.id = ph.pid
    LEFT JOIN tb_favorite f ON ph.fid = f.id
    GROUP BY
    	u.id