Populating a Bootstrap dropdown from an MS SQL Database

I've been racking my brains all morning, and I have searched on loads of pages via Google.

I can't find a way to populate a bootstrap button dropdown box with data from a MS SQL server.

Plenty of ways to do a plain HTML dropdown from MySQL.

This is the code of the button:

<div class="btn-group">
    <button type="button" class="btn btn-info btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Family</button>
    <div class="dropdown-menu">
        <a class="dropdown-item" href="#">Option 1</a>
        <a class="dropdown-item" href="#">Option 2</a>
        <a class="dropdown-item" href="#">Option 3</a>
     </div>
 </div>

Help is kindly appreciated.