Laravel Get Childest category(last child which has no child) with a specefic column equal true

I have a Category table in my project, and it has a “parent_id” column, as you can guess, every Category can have many children, and every child can have many children too.

So in the scenario, how can I get the last child of every Category in the Laravel model that has no child anymore.