how to make a pedigree / hierarchy of work all generations

The data is about dogs, but I think many of the same things apply to a family tree.
SEMrush

I have at the table some data looking like this:
First name; reg; Reg_Father; Father; Reg_mother; Mother; Born; count
; Prince; NO34567; NO12345; King; NO23456; Queen;

2016-12-30;

5

The primary key is the value "Reg" and this refers to "Reg_father" and "Reg_mother", these are all known values. "Name" is related to "Reg" in the same way that "Reg_father" is to "Father" and "Reg_mother" is to "Mother"

What I like to do, it is
1. be able to create a "family tree" and list the current ancestors
2. How often do these ancestors appear in the lines. Name or Reg with an account behind.

ideas of how best to achieve this goal?

BR
Jimmy

wp query – WordPress | WP_Query | The publication & # 39; offset & # 39; does not work and posts_per_page is not set to -1

Why does my random publish request ignore the offset value?


    & # 39; & # 39 ;, post
& # 39; post_status & # 39; => & Quot; publish & quot;
& # 39; category_name & # 39; => & # 39; social network & # 39 ;,
& # 39; posts_per_page & # 39; => $ number_of_recent_posts,
& # 39; orderby & # 39; => & # 39; post_date & # 39;
& # 39; order & # 39; => & # 39; DESC & # 39;
)
$ rec_arr_posts = new WP_Query ($ recentargs);

if ($ rec_arr_posts-> have_posts ()):

while ($ rec_arr_posts-> have_posts ()):
$ rec_arr_posts-> the_post ();
?>
<div class = "gys-cube-cube-gys-cube" style = "
            
                padding: calc (px / 2);
            
        ">
<div class = "cube-inner" style = "
                
                    padding: calc (px * 2);
                
                
                    
                    
                    
                    Color: ;
                
                
                    
                    
                    
                    font size: px;
                
                
                    
                    
                    
                    Background color: ;
                
                
                    
                    
                    
                    background-image: url (& # 39;& # 39;);
                

                ID)):?>
                    ID), & # 39; single-post-thumbnail & # 39;); ?>
background-image: url (& # 39;& # 39;);
                
            ">

<a href = ""class =" box-link "target =" _ blank ">
                <div class = "cube-inner-hover" style = "
                    
                        -webkit-transition: background color easing;
-moz-transition: background color easing;
-o-transition: background color easing;
transition: background color easing;
                    
                ">