Providing Absolute Page Number and Sectional Page Number on the same page.

Peter S beat me to it! However, shouldn't those frames be threaded for the numbers to display correctly?

You can't do that in InDesign: references to page numbers, using cross-references or variables, are always to folios (or displayed page numbers). But it's fairly easy to set up for a script.

First, add a text frame for the abslute page numbers to the master pages and name it 'abs page num' on the Layers panel:

 Then run this script:

(function () {
  
  var pp;
  var frame;

  function overrideAbsoluteFrame (page) {
    var f = page.textFrames.item ('abs page num');
    if (!f.isValid) {
      var m = page.masterPageItems;
      for (var i = 0; i < m.length; i++) {
        if (m[i].name === 'abs page num') {
          f = m[i].override (page);
        }
      }
    }
    return f;
  }


  function pad (n) {
    if (n < 10) {
      return '0'+n;
    }
    return String(n);
  }


  pp = app.documents[0].pages.everyItem().getElements();
  for (var i = 0; i < pp.length; i++) {
    frame = overrideAbsoluteFrame (pp[i]);
    frame.contents = pad (pp[i].documentOffset+1);
  }

}());

If pages are added or deleted, simply run the script again.

P.

One method would be to add a text frame to the Parent/Master pages with a space in it and define the paragraph as a numbered list.