Mysql:select 查询执行计划出现了 Using filesort 该如何优化

sql 语句如下，该如何优化，请 V 友提供一些思路

SELECT * FROM ( SELECT mp.id, mp.mp_name, mp.weixinname, mp.biz, ifnull(mp.head_img_url, '') AS head_img_url, ifnull(mp.qr_code_url, '') AS qr_code_url, mp.introduce, mp.company_name, mp.first_average_num, mp.average_num, mp.souce_mp, mp.souce_article, mp.is_auth, mp.push_num, ifnull(mp.update_time, '') AS update_time, ifnull(mp.create_time, '') AS create_time, IF (mal.biz <> 'null', 1, 0) AS is_storage, max(ifnull(mal.create_time, '')) AS import_time, any_value (ifnull(art.read_num, 0)) AS read_num, any_value (ifnull(art.like_num, 0)) AS like_num FROM `wd_mp_library` mp LEFT JOIN wd_mp_library_formal mal ON mp.biz = mal.biz LEFT JOIN wd_mp_library_about_articles art ON mp.biz = art.biz WHERE mp.isdel = 0 GROUP BY mp.id ) a LIMIT 25, 20;