How do I redistribute child elements if the parent is deleted?

Question

Laravel

Hello. There is a table for example category with fields id | name | parent_id

For example, there is such data in the table
Here is a link to json https://jsoneditoronline.org/?id=575f6dafdca44bbf9...
Or an array below

spoiler

stdClass Object
(
    [1] => stdClass Object
        (
            [name] => q
            [children] => stdClass Object
                (
                    [3] => stdClass Object
                        (
                            [name] => e
                            [parent_id] => 1
                            [children] => stdClass Object
                                (
                                    [4] => stdClass Object
                                        (
                                            [name] => r
                                            [parent_id] => 3
                                        )

                                    [5] => stdClass Object
                                        (
                                            [name] => r
                                            [parent_id] => 3
                                        )

                                )

                        )

                    [6] => stdClass Object
                        (
                            [name] => y
                            [parent_id] => 1
                            [children] => stdClass Object
                                (
                                    [7] => stdClass Object
                                        (
                                            [name] => u
                                            [parent_id] => 6
                                        )

                                )

                        )

                )

        )

)

So that's the QUESTION
For example, I'm deleting an element with id = 3 that has children id = 4,5
How can I make these child elements distributed among other elements? Those. so that they do not have parent_id = NULL (Only 7 elements are taken here, but there will be more than 20,000)

Answer 1

Subscribe to event deleting/ deletedmodels and distribute child elements to other elements.

Answer 2

You can also use JSON Editor to parse JSON data