Question

mysql怎么查询a表中的所有字段统计b表中aid字段等于a表id的个数

Answer 1

试试这个方法：SELECT id, name, (SELECT comment_id, title, content FROM B WHERE user_id = A.id ORDER BY create_time DESC LIMIT 1) FROM A;