MySQL多表关联，取一表字段的最大/小值

先用表关联查询，条件语句中嵌套需要查询的对大/小值的id
或者直接用t1 jion t2最大值的子查询结果也可以

SELECT
	t1.id,
	t2.*
FROM
	 t1
INNER JOIN  t2 ON t1.id = t2.p_id
WHERE
	1 = 1
AND t2.id IN (
	SELECT