如何在mysql中使用in关键字时获得有序的结果集

I am trying to run the below query in order to get ordered data from category_child table and accordingly from the category table. select * from category where id in (select child_id from category_child where category_id=1 order by sequence);I am trying to run the below query in order to