MYSQL 一个查询语句求助

Question

查询log表，log表的class_id和class表的id关联。通过class_id=1 要查询出log表的1和4这两条记录（project_id都等于101），这个语句该怎么写？

Answer 1

select log.* from log left join class on class.id = log.class_id where log.class_id in (select id from class where project_id = (select project_id from class where id = 1));