Help writing Sql with CI4 active record

Hello. I 'm struggling to write sql with subquery, How can I write it with codeigniter methods.
Thanks!

//SQL

PHP Code:

SELECT p.id, p.catId, p.image, c.id, (c.name) as category
                FROM product_feature p
                JOIN categories c ON p.catId = c.id
                WHERE p.id IN(
                    SELECT MAX(p.id) FROM product_feature p 
                    GROUP BY p.catId 
                 )