Delete data from 3 different tables (Codeigniter)

Question

I am trying to delete photos from a view, however, I need to delete beyond the photo table the data from two more tables that are linked to this photo.

The code with the delete function is as follows:

function deleteImage($id)
{
    $this->db->select('idImagem')->from('tbdimagem')->where('idImagem', $id);
    $subQuery =  $this->db->get_compiled_select();

    $tabelas = array('tbdsubcategoria', 'tbdcategoria', 'tbdimagem');
    $this->db->where('idImagem', $subQuery);
    $this->db->delete($tabelas);
}

But it returns this when executing the function in the view:

EDIT 1

EDIT 2

Table Image

Table Category

Table Subcategory

Answer 1

I’d do it this way

function deleteImage($id){

    $this->db->where('idImagem', $id);
    $delete_tbdsubcategoria = $this->db->delete('tbdsubcategoria');

    $this->db->where('idImagem', $id);
    $delete_tbdcategoria = $this->db->delete('tbdcategoria');   

    $this->db->where('idImagem', $id);
    $delete_tbdimagem = $this->db->delete('tbdimagem');

}

Answer 2

I managed to solve, in the two tables 'daughters' I had to put the parameter 'on delete' in foreign keys. After that, I was able to delete the data from the 'parent' table'.